Operations Manager has stacks of reports to help you monitor your applications' uptime, but reporting can be difficult until you understand all the different options, parameters, and the structure of the Operations Manager health model. Firstly, you need a clear idea about the way that your organization defines 'uptime', and only then you can start your reports. Thomas LaRock explains...
2009-03-27
1,755 reads
Operations Manager has a number of reports to help you monitor the uptime of your applications, but reporting can be difficult to learn until you understand all the different options, the different parameters possible, and the way the Operations Manager health model is structured. Firstly, you need a clear idea about the way that your organization defines 'uptime'. then you can start your reports from any of the views in the Monitoring tab, and then add or remove objects to get the report you need.
2009-03-16
1,539 reads
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
2008-11-06
2,392 reads
Longtime expert DBA Thomas Laorck brings us a short article about how he uses Operations Manager to watch the SQL Servers he is responsible for and ignore others.
2008-07-23
5,937 reads
An overview of how to collect data from TSQL into Operations Manager Performance Rules.
2008-06-05
7,062 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;