OK, here are details of my problem.
I have a server with IIS 5.0 and SQL Server 2000 installed. I have
more than 20 web sites and databases associated with them which are
all running fine.
I have a problem with one database.
I connect using SQL Query Analyzer to the database and type a pretty
basic insert query. This takes 40-50 seconds to execute.
Then I try the same insert query and it takes less than a second. It
works fine, but then I don't know how or when, it gets broken again
and it again takes 50 seconds to execute.
To make the long story short, insert query takes long time to execute
for the first time but the rest takes very short time.
I can give you access to my sql server by inviting you to my server
using gotomypc.com
Thanks for your help in advance. |
Request for Question Clarification by
mathtalk-ga
on
13 May 2004 09:17 PDT
When you describe the insert query as "basic", do you mean that you
are using the INSERT ... VALUES (...) syntax to insert a single row?
How do you connect to the database using SQL Query Analyzer? Are you
using a TCP/IP connection or named pipes? Are you using SQL Server
authentication or domain authentication? Is the query client on the
same machine or a different machine as the database (and IIS 5.0)?
Finally, have you tried bringing up the Performance Monitor applet
during these long time lapses, to see if either CPU or disk activity
is high?
regards, mathtalk-ga
|
Clarification of Question by
dynamicdealer-ga
on
13 May 2004 09:35 PDT
Yes, I ony insert one row...
I am using tcpip connection and using windows authentication.
Yes it is on the same machine.
No i didn't check the performance monitor. as i said it goes away
after the first insert query then comes back i don't know 10 hours
later...
|
Request for Question Clarification by
mathtalk-ga
on
13 May 2004 12:05 PDT
One thing to try is changing the SQL client configuration to use named pipes.
It sounds like either a "network" latency issue (routing to
localhost?) or that SQL Server 2000 is configured with minimal
reserved memory and has to page out quite a bit of stuff unrelated to
your INSERT before it has room to do that. In the latter case the
performance monitor (right click on the toolbar and select Task
Manager and its Performance tab) will be able to show you disk
activity (assuming its not obvious from a disk activity light on the
front panel of your PC).
regards, mathtalk-ga
|
Clarification of Question by
dynamicdealer-ga
on
21 May 2004 16:42 PDT
No, sir...if you need i can give you access to the server via webex like service...
|
