Category Archives: SQL Server DBA

Drill Down Reports in SSRS with examples

Posted on May 1, 2013 by uday arumilli

Drill Down Reports in SSRS with examples We will see how to deal with drill down reports in SSRS with examples. For this report you can create a table and populate data from the post. Let’s create a report using … Continue reading →

Posted in MSBI, SQL Development, SQL Server DBA, SSRS | Tagged , , , , , , , , , , , | 5 Comments

Low Level SQL Server Architecture

Posted on April 15, 2013 by uday arumilli

Low Level SQL Server Architecture   Here I would like to describe the process architecture whan a new request submitted to SQL Server. I have submitted a Query to SQL Server from an Application and I got the reply as … Continue reading →

Posted in Database Design, SQL Development, SQL Server DBA | Tagged , , , , , , , , | 2 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