April 8, 2014 at 11:04 pm
Hi,
In one of my critical production server not able to connect i check in event viewer the given below errors are frequently occured. Once restart the SQL services then can able to connect.
Kindly provide me solution to fix this issue its very urgent.
"SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=6032. Thread=11856. Client. Instance=SQL2008R2. VD=Global\BE_SQLAgent-frost__4a43fbe7_bf8b_4674_9087_ea09612c921a__SQLVDIMemoryName_0."
"New queries assigned to process on Node 0 have not been picked up by a worker thread in the last 60 seconds. Blocking or long-running queries can contribute to this condition, and may degrade client response time. Use the "max worker threads" configuration option to increase number of allowable threads, or optimize current running queries. SQL Process Utilization: 0%%. System Idle: 99%%."
Pradeep
April 9, 2014 at 5:53 am
First, follow the suggestion and increase your max worker threads. That will both alleviate the issue and make it worse at the same time. It sounds like your system has some badly performing queries. You need to identify these and tune them. The details on how to do this are in the books linked in my signature.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2014 at 9:52 am
What's the "max worker threads" option for your SQL Server ? And is your SQL Server 32 bit or 64 bit ?
--
SQLBuddy
April 11, 2014 at 3:55 am
64bit OS and max work thread is set to default '0'
Pradeep
April 11, 2014 at 11:16 am
pradeep.mohan (4/11/2014)
64bit OS and max work thread is set to default '0'
Do you see any blocking\memory issues on the server ?
--
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply