0
votes
0answers
65 views

Changing how tempdb log space is monitored in SCOM

We are monitoring our SQL installation with SCOM. We get an alert about once a day saying that the log file in tempdb is filling up. However, because checkpointing works differently in tempdb than it ...
2
votes
1answer
655 views

SCOM 2007 - SQL Server Monitoring

I've been tasked with comparing the monitoring capabilities in SCOM 2007 with the established SQL products such as Spotlight, SQLSentry, etc. I'm pretty sure that SCOM can't do some of the more ...
2
votes
1answer
704 views

How to migrate SCCM and SCOM's databases from SQL Server 2005 to SQL Server 2008?

I need to migrate databases (including reporting services) applications System Center Operations Manager and System Center Configuration Manager to a single SQL Server 2008. Currently each of the ...
0
votes
1answer
399 views

Custom rules in SCOM 2007

Our networking department uses Microsoft's System Center Operations Manager 2007 (formerly MOM) to monitor servers. We want to check if a particular SQL Server database is being updated (basically if ...
1
vote
1answer
438 views

SCOM 2007, Sql Audit event

I'm new to SCOM 2007. Im trying to setup alerts and views for failed SQL login attempts. I've been on the internet for hours without any luck. My test case is trying to connect to SQL server on the ...
3
votes
3answers
3k views

Correct settings for tempdb to avoid significant changes in free space

Every two to three days we are getting the following SCOM error: The database tempdb in SQL instance MSSQLSERVER on computer sqlserver has experienced a significant change in free space ...