sys.dm_os_performance_counters empty
Jan 9, 2015 · All I have to do is restart the SQL Server Service and sys.dm_os_performance_counters is populated again. I am using …
Run this resource in a separate Resource Monitor setting
Mar 10, 2020 · The resource monitor provides a communication, monitoring, and processing layer between the cluster service and one or more resources. The resource monitor always runs in …
Monitor SQL agent jobs in SCOM - social.msdn.microsoft.com
Jan 19, 2010 · the sql agent job state is empty, how should i add all the jobs for a perticular db for monitoring. kindly help Friday, January 8, 2010 3:55 AM 0 Sign in to vote Hi how can i search …
Release free space from MDF File - social.msdn.microsoft.com
Feb 18, 2017 · Shrinking a database should be a rare operation and should not be part of your regular database maintenance. Heavy shrinking and growing of database files will fragment …
How much disk queue spiking is normal?
May 27, 2010 · Performance counters tend to be one of the last things I look at when I am trying to figure out bottlenecks for a SQL Server. The Wait and File statistics inside SQL tell a better …
Cannot perform a differential backup for database
Apr 12, 2010 · The next differential backup executed by SQL Server then fails with the same sorts of errors reported here in this thread. If I run NTBACKUP with snap ff then the problem …
3GB Memory for sql server - social.msdn.microsoft.com
Aug 3, 2009 · It depends on the fact that if the box is dedicated to SQL Server alone or there are any other applications along with SQL Server. SQL Server by default, takes as much memory …
Missing SQL Collation - social.msdn.microsoft.com
Jul 7, 2015 · The server as well as the database collation are only default value for DDL Statements without explicit defined collation setting; the effectiv collation is defined on column …
Some AODB Connections Stopped Working Against Some …
Nov 15, 2010 · Stuff that has worked for years quit working in specific circumstances in September. "Stuff" is a web application that invokes a Visual Basic Module that opens an …
How to recover job history - social.msdn.microsoft.com
Feb 8, 2011 · If you have a backup of your MSDB database before the delete was performed then use that backup and restore the msdb with someother name call it TEST_msdb in your prod …