Troubleshooting THREADPOOL Waits
Today I want to talk about a specified wait type that can be sometimes very hard to
troubleshoot: the THREADPOOL wait...
2011-10-25
12,601 reads
Klaus Aschenbrenner
Query Memory Spills
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,139 reads
Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS
As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS
today, you can find here the
slides & samples for...
2011-10-14
782 reads
SQL Server Indexing Day, 18. Jänner 2012 in Wien
Sie wollen SQL Server
Abfragen um 100% oder gar 1000% beschleunigt haben? Gleichzeitig wollen Sie Hardware–
und Lizenzkosten Ihrer SQL Server Anwendungen...
2011-10-04
1,083 reads
Slides & Samples from my SQLbits sessions
As
I have announced in all of my sessions at the SQLbits conferences in Liverpool/UK,
you can find here the
Slides & Samples for...
2011-10-02
919 reads
Slides & Samples for my SolidQ Summit Sessions
As I have announced in all of my sessions last week in Budapest at the SolidQ summit,
you can find here...
2011-09-29
1,479 reads
Slides & Samples for my SQLdays Sessions
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays
conference can find here the
Slides...
2011-09-29
1,413 reads
SQLMCM Training – Day 18
Today we covered the topics Full Text Search, Change Data Capture, Change Tracking,
and Service Broker. I have taken no notes...
2011-08-26
978 reads
SQLMCM Training – Day 17
Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...
2011-08-25
678 reads
SQLMCM Training – Day 16
Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...
2011-08-24
636 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers