Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.
Interview Question of the Week #028 – Few SQL Best Practices
Just last week, I moderated a SQL Server interview and I heard very interesting conversation. Question –Â What are the best practices are you following for SQL Server? When I heard this question – I thought candidate will answer many different things, but he was stunned and had nothing much to…
Read MoreSQL SERVER – Querying Performance Counters from SQL Server
Troubleshooting SQL Server is something almost every single DBA has to go through in their lifespan. It sounds simple and often we are clueless on where to start. Here is a scenario, you have been told that SQL Server is slow or unresponsive. Now you need to troubleshoot and figure…
Read MoreInterview Question of the Week #021 – Difference Between Index Seek and Index Scan (Table Scan)
Question: What is the difference between Index Seek and Index Scan? Answer:Â Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. Index Scan: Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the…
Read MoreSQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)
While talking to one of the attendees after my session at GIDS, I realized that I don’t have much information available on my blog about the usage of one of the fantastic performance tuning tool called Database Engine Tuning Advisor. This is also called as Database Tuning Advisor or DTA…
Read More
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A lot of times, I have seen DBA’s and administrators have their own startup tasks that they perform when rebuilding or bringing a new server online. Some of these practices are powerful and are mean to enhance performance of the box that you have bought. Recently, I was at a customer location looking at what a typical Admin was doing and this step of his caught my attention. I couldn’t stop myself from blogging this because it was a simple, powerful and yet less appreciated setting available on the Server. Let us learn Power Plan for SQL Server.
SQL SERVER – 8 Performance Related Articles on Logical Reads
Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subject of SQL Server Performance. I have really enjoyed writing them and I am very confident…
Read More