Tag Archives: Administration

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:

Posted on June 10, 2013 by uday arumilli

SQL Server: Incorrect PFS free space information for page (1:xxxx) in object ID xxxxxx:   “Incorrect PFS free space information for page (1:233791) in object ID 367392428, index ID 1, partition ID 72057594180730880, alloc unit ID 72057594222018560 (type LOB data). … Continue reading →

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 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