Alan's Blog

"Yeah. I wrote a script that will do that."

Check SCCM TempDB space

Posted on October 13th, 2011

Sometimes a poorly framed query or collection can cause SCCM collections to be left forever in an evaluation state. As a result, the TempDB for the SCCM server can grow to the point where it fills the available drive space. When that happens, SQL stops, and SCCM stops.
Some advice: TempDB is recreated when the SQL Server service is restarted. This is your first action to clear the problem. You should thereafter restart the SMS Executive service.

As the tempdb begins to grow, you can find out what is going on by looking at reports. In the SQL Server Management Studio, expand system databases, right clicking on tempdb, and┬áselecting Reports/Standard Reports. “Top Transactions By Age” will show you what has been stuck, and can give you evidence to track back from there.

In a large SCCM environment, keeping track of the tempdb can be time consuming. SCCM TempDB Space.vbs will connect to the SCCM database and report tempdb size, path, and free space from all site servers. The script has some interesting combinations of WMI queries and SQL queries.

Tags: ,
Filed under SCCM, SQL, VbScript, WMI | No Comments »

Please Note

All the scripts are saved as .txt files. Newer files have a "View Script" button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use "Save Target As". Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with Version 3 or 4.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient. It is pretty easy to figure out my email address from the scripts, and you are welcome to contact me that way.

Site Search

Categories

Archives

SQL Site

Bad Behavior has blocked 169 access attempts in the last 7 days.