March 31, 2012 at 9:41 am
Hi
i m using SQL 2008 , last 3 years it was working proper now i m facing problme after 3 or 4 hrs it become slow, once i restart server it work for next 4-5 hrs, please give me some tips about to resolve this issue
March 31, 2012 at 12:06 pm
It's impossible to "guess" what it could be.
Have a look at your error logs, collect performance data, check if jobs are running etc.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 31, 2012 at 1:01 pm
April 1, 2012 at 6:35 am
Another vote for reading Gail's excellent articles.
You can take a look at sys.dm_exec_requests to see if you're getting blocking on any of the processes. I'd probably start there on a cursory check of performance issues.
Otherwise, you need to gather metrics, especially wait states and queues, in order to understand what's happening with the system. I outline how to do that in my book, linked below.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply