October 12, 2012 at 5:37 am
Hi Experts,
Team is complaining that their database is slower than usual and reports are not getting generating and everything is in queue. I checked the server and didnt find anything unsual other than three jobs which where using high physical io.
Checked CPU,MEMORY
Blocking
Is there anything need to check other than this initially??
I found one thing strange is that when connected through ssms the server was showing red(normally stopped) but was able to connect and query.
Please help
October 15, 2012 at 1:47 am
go to the services section and check the status " running or stopped" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 3:26 am
I found two servers showing the red stop icon i checked the services and its showing running for one server and stopped for the other one.
October 15, 2012 at 3:33 am
Ratheesh.K.Nair (10/15/2012)
stopped for the other one.
Check if it is related with above mentioend reporting server and wheher it is intentionally stoped ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply