I installed SQL vNext CTP 1.4 on Windows 2012 R2 and some Linux Machine in order to compare performance. Basically Write Access is compara...
Read More
Home / Performance
Showing posts with label Performance. Show all posts
Showing posts with label Performance. Show all posts
CPU usage per database
This script shows all CPU usage of all sessions per database at a certain moment. DECLARE @total INT SELECT @total=sum(cpu) FROM sys.sysproc...
Read More
SQL Memory Performance Issues
If you're wondering if your SQL Server is lacking Memory, you can get your answer easily checking these Performance Counters Threshold...
Read More
Subscribe to:
Posts
(
Atom
)