Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
673 reads
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
673 reads
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...
2013-05-21
1,832 reads
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,445 reads
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,714 reads
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,307 reads
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,011 reads
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
647 reads
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,339 reads
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
843 reads
Can you tell me the drive we were backing up server #58 to exactly 8 months ago, and, if possible,...
2013-05-14
417 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hello all, I would like to create an INSERT statement and use a UDF...
Comments posted to this topic are about the item Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers