Browse by Tags
All Tags »
SQL (
RSS)
Open transactions - transactions that run too long or are hung - can cause havoc on the ConfigMgr database. Notice a backlog of files (DDRs or Mifs)? Slow...
Here is a quick and dirty SQL script that will list the site maintenance tasks and how long they ran last. Run this in SQL Management Studio and target...
This is a handy little SQL statement we managed to whip up while working on a discovery problem. This script will show you a count of Machine based discoveries...
SQL server uses statistics to keep track of values in an index, and determine when and how to use that particular index while processing a query. This...
If you suspect that you have fragmented SQL indexes in your ConfigMgr database (confirm those suspicions here ), then what are your options? You could...
While working on a performance problem with a couple of very talented SQL gurus I was handed this script. It checks, among other things, the fragmentation...
Ever wonder what is taking up all the space in your ConfigMgr database? This SQL query will show row count, reserved/used data size, and reserved/used...