Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.
2019-04-15 (first published: 2010-05-11)
15,325 reads
Does too much uptime mean that you might be at risk for downtime? Steve Jones examines this idea in today's editorial.
2009-08-03
94 reads
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
What is the difference between the SQL Agent Startup account (Agent...Properties...General tab) and the SQL Server Connection account (Agent...properties...Connection tab)I have always assumed that the Agent Startup Account is used when running scheduled DTS packages, replication etc. but don't know what the connection account is used for.Can anyone provide me with 2 scenarios one that […]
2004-09-08
2 reads
2004-09-07
HiIn a new system we are designing, we are considering using parent-child tables to maintain dimension hierarchy data. From these. AS can easily create parent-child dimensions in our MOLAP cubes, but a consultant has said that when processed, no aggregations will be held for the parent-child dimensions.I have tried to find documentation on this but […]
2004-09-07
1 reads
I have a server where there is heavy file fragmentation but it is quite busy and cannot be down for long periods of time. Is there any way other than shutting down SQL Server that would allow me to run a defrag on the datafiles while the the database files are in use?
2004-05-11
having the same issue It will work for the default instance, but not for the others.
2004-02-25
Sounds like something has marked the file 'E:\Backup\TCPrdLog.BAK' in use and cannot be opened or written to. Could be a bad thread in memroy still locking and might requried restarting the server to clear.
2003-11-21
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers