Category Archives: Performance Tuning

SQL Server Performance Tuning Interview Questions – Part 1

Posted on December 17, 2014 by uday arumilli

Sql Server Performance Tuning Interview Questions Performance Tuning – SQL Server  Part – 1 Q. What are the bottlenecks that effects the performance of a Database / Application Ans: The top performance bottlenecks for OLTP applications are outlined as: Database … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 47 Comments

Interview Questions

Posted on October 4, 2014 by uday arumilli

sql server experienced interview questions Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 ​ Organization … Continue reading →

Posted in High Availability, Interview Q&A, MSBI, Performance Tuning, SQL Development, SQL Server DBA, SSIS, SSRS | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 68 Comments

Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server

Posted on March 20, 2013 by uday arumilli

 Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server CPU Usage, I/O Usage and Memory Usage of database   Database level / Database wise CPU, memory and I/O usage As part of DBA’s daily checklist, we need to … Continue reading →

Posted in Performance Tuning, SQL Server DBA | Tagged , , , , , , , , , , , , , | 1 Comment