Finn McCool

Checking TempDB

On SQLServer forums you will often find advice on how to configure Tempdb. How many files should you add, what should be the sizes, and also what Traceflags should be enabled to correctly enhance the performance of your TempDB?

Paul Randal wrote this:

http://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/

I created a PowerShell script to check the TempDB files and the startup parameters on one or more SQL Server instances in one go.

ManagedComputer error on SQL Server 2012

Here's a short discovery on managing SQLServer Services with PowerShell. There are multiple ways for almost all tasks, but some are more suited than others. If we explore the use of WMI, SMO, the PS Provider and especially SQL WMI Provider, not every combination is successfull. Is there something wrong on my configuration? Or did I find a bug?