Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-20 : 08:25:45
|
| Zaid Rahman writes "Hello,I redesigned a site that was using an access db to now use SQL Server. I am noticing intermittent timeouts on different queries. I started using perfmon to see if I can see what could be the cause. I notice rather large spikes on the Logins/sec and Logout/sec counters. Can this be explained?ThanksZAID" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-20 : 12:32:08
|
| I don't have an explanation as to your spikes for logins and logouts, but for timeouts you need to figure out which queries are timing out first by running SQL Profiler. Then you should either send your trace file through the index tuning wizard or manually analyze the queries to determine what can be optimized. You probably just need to add an index here and index there type of thing. Or you might need to add some statistics or maybe even rebuild your indexes. See SQL Server Books Online for the details on the last two.Tara |
 |
|
|
|
|
|
PerfMon spike on Logins and Logouts / sec