Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting database Slow Expand / Collapse
Author
Message
Posted Friday, October 12, 2012 5:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:54 AM
Points: 2,621, Visits: 3,940
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
Post #1372038
Posted Monday, October 15, 2012 1:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 29, 2014 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1372584
Posted Monday, October 15, 2012 3:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:54 AM
Points: 2,621, Visits: 3,940
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.
Post #1372622
Posted Monday, October 15, 2012 3:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 29, 2014 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1372626
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse