June 27, 2009 at 1:20 am
Following error occured on ML 350 server.
-214721781 [Microsoft][ODBC SQL Server Driver]Timeout expired
My database size in 30 GB.
I have checked everything and all the settings are ok.
DBCC check db
dbcc updatestats
query timeout is aslo set maximum.
Normally db works fine but when i excute comlicated queries the error occured.
pls help.
Thanks.
June 27, 2009 at 3:27 am
naimshad (6/27/2009)
Following error occured on ML 350 server.-214721781 [Microsoft][ODBC SQL Server Driver]Timeout expired
My database size in 30 GB.
I have checked everything and all the settings are ok.
DBCC check db
dbcc updatestats
query timeout is aslo set maximum.
Normally db works fine but when i excute comlicated queries the error occured.
pls help.
Thanks.
Check out for index fragmentation? This may be the reason for queries to take long running time.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply