2010-04-15 (first published: 2010-03-28)
4,903 reads
Mircea Nita
DBA Tools: sp_whocpu
The Stored Procedure sp_whocpu shows cpu_delta - a metric I introduced to define the real time CPU activity
2010-04-14 (first published: 2010-03-28)
3,390 reads
DBA Tools: sp_whoio
The Stored Procedure sp_whoio shows DiskIO_delta - a metric I introduced to define the real time I/O activity
2010-04-12 (first published: 2010-03-28)
3,783 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server 2016 seeding automatic stuck
Hi all, Problem help please, I have 2 servers in sql server 2016 and...
will this get replicated to secondary replica
Dear Experts, In Availability Group, if we move ndf file to another drive on...
slow query performance
Hi All, I have a SELECT query which is taking more 8 mins. Can...
Ask SSC