PBM Policy / WMI query to see which CPUs are in power-saving mode
A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.
2017-06-06 (first published: 2011-01-14)
1,659 reads
Ben Whitman
Optimising “Ends With” searches with REVERSE
A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text
2010-01-13
9,401 reads
Blogs
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Introduction to SQL Server Execution Plans
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Forums
Evergreen SQL Server
Comments posted to this topic are about the item Evergreen SQL Server
Do you really know what’s happening with your servers?
Comments posted to this topic are about the item Do you really know what’s...
Going from long to wide
Comments posted to this topic are about the item Going from long to wide
Ask SSC