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.
-
- Influencer
- Posts: 12
- Liked: 3 times
- Joined: Mar 01, 2011 3:11 pm
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Reporter TempDB status
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.
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.
-
- Influencer
- Posts: 12
- Liked: 3 times
- Joined: Mar 01, 2011 3:11 pm
Re: Reporter TempDB status
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.
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.
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Reporter TempDB status
I've just checked and my installation shows as "False" by default, so seems like you've nailed it.
Who is online
Users browsing this forum: No registered users and 3 guests