Slow SQL Server using ASP Pages

I am working on a site where its on a dedicated server and the SQL Server is dedicated on another server. We are waiting for the original SQL CD to come into the mail so I installed the 120 Trial version of SQL. We are having problems with the pages takes about 4 - 5 seconds on average to be processed by the web server. I added in some ASP code to show a timer in different areas of the code to see what was causing the slowdown. It seems that around...

If (rsConfig.RecordCount <> 0) Then

Is the first time the code takes to long to process. Each server is behind its own snapgear firewall. Anyone have any ideas on why it would be taking so long to process the SQL? I did not install any Service Packs (which I will try tommorow) because I was thinking that if Microsoft had some problems they would recompile the trial version install. Is the Trial version limited in anyway? If so could this be causing slow processing times from the SQL Server?

 

 

 

 

Top