Reporter TempDB status

Management reporting and documentation

Reporter TempDB status

Veeam Logoby steve_mc » Fri Nov 18, 2011 9:40 am

Hi,

Our SQL Server management pack in SCOM is generating alerts regarding the state of the Veeam TempDB database as being 'offline'

Alert:
Database ....... in SQL Server instance VEEAMSQL2008 on computer ReportServer$VEEAMSQL2008TempDB is offline/recovery pending/suspect/emergency

This occurs a few times over the course of a week. Should the TempDB database go into offline mode by design (in which case I will override this alert in SCOM) or is this something worth further investigation?

Thanks,

Steve.
steve_mc
Influencer
 
Posts: 12
Liked: 3 times
Joined: Tue Mar 01, 2011 3:11 pm

Re: Reporter TempDB status

Veeam Logoby Vitaliy S. » Fri Nov 18, 2011 9:57 am

Hi Steve,

I believe that it is something worth investigation, as TempDB shouldn't go offline. I would suggest consulting with your DBA as there might some issues with SSRS itself.

Thanks.
Vitaliy S.
Veeam Software
 
Posts: 19704
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Reporter TempDB status

Veeam Logoby steve_mc » Fri Nov 18, 2011 10:59 am

Hi Vitaliy,

Thank you for your quick response. When I drive into the SQL Server Management Studio > Database Properties > Options, the database (both the VeeamSQL2008 TempDB and VeeamSQL2008 databases) have the "AutoClose" option set to "True".

Can you confirm if this should infact be set to "False" for either of these databases ?

Thanks,

Steve.
steve_mc
Influencer
 
Posts: 12
Liked: 3 times
Joined: Tue Mar 01, 2011 3:11 pm

Re: Reporter TempDB status

Veeam Logoby Vitaliy S. » Fri Nov 18, 2011 1:14 pm

I've just checked and my installation shows as "False" by default, so seems like you've nailed it.
Vitaliy S.
Veeam Software
 
Posts: 19704
Liked: 1117 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Reporting



Who is online

Users browsing this forum: No registered users and 2 guests