SQL Server Performance Forum – Threads Archive

random sql problem.

Background:
I maintain an application that connects to an M$ SQL database using ADO and ODBC. My application and database have been running fine for quite some time, but as of monday/tuesday I’ve been running into this on/off problem that seems to only affect this 1 program. Basically, what happens is that everyone running my application starts timing out no matter what the query is. One of the first tables that it opens is only 4 records long which normally takes nearly no time.
querys from outside my app work. Other applications using the same connection methods are still working. I started to receive the error "Error: 9002, Severity: 17, State: 6" which says that the tempdb is full. ok, simple enough i thew a bunch of space at tempdb and its not even close to its limit. however the problem came back. I can’t find any errors in the server logs, or SQL logs. I’ve backed up the db and ran a number of maintance utilities but that didn’t seem to change anything. I can’t pinpoint any causes, nor can i predict the amount of time between each occurance. SQL server setup is:
windows 2k3
sql 2k, 8.00.818
Any clues where to look would be very much appreciated.
-Mike

Followhttp://msdn.microsoft.com/library/en-us/trblsql/tr_reslsyserr_2_18s2.asp to troubleshoot 9002.
http://www.databasejournal.com/features/mssql/article.php/1493621 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>