SQL server 2000 sometiems it's very slow
Posted on 2005-05-09
We recently converted all our data from Access to SQL server.
Apps seem to work fine, no major problem except for once in a while it's so slow to pull up a record. One of our apps running on 20,000 records database, when it's slow it takes a good 10 seconds as opposed to a usual 2 seconds just to pull up a record. In both cases, there is absolutely no other user on the network except me testing. So I really don't know where should I start to trobleshoot this.
So please anyone, any suggestions into how to fix this would be appreciated