Management reporting and documentation
Post Reply
steve_mc
Influencer
Posts: 12
Liked: 3 times
Joined: Mar 01, 2011 3:11 pm

Reporter TempDB status

Post by steve_mc » 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.

Vitaliy S.
Product Manager
Posts: 22973
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter TempDB status

Post by Vitaliy S. » 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.

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

Re: Reporter TempDB status

Post by steve_mc » 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.

Vitaliy S.
Product Manager
Posts: 22973
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Reporter TempDB status

Post by Vitaliy S. » 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.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 1 guest