Script to check whats hogging the system
This script takes 2 samples over a 10 second period to identify what spids are using most resources. It's probably not 100% accurate but it's helped me out a few times.
2003-05-15
488 reads
Blogs
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to...
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or...
Forums
error Output File cleanup does not delete files script d'olla
Hello everyone, I use olla scripts in my backup and maintenance operations there is...
Help with a stored procedure
I have a table "Mytable" containing a list of IDs. There is a web...
Need to perform leaf level aggregation
So I have a DW with a table with some pre-aggregated scores (not my...
Ask SSC