What is the role of the DBA in a world where Cloud is being adopted more and more each day? This is a question I’ve had to answer multiple times in various sessions […]
Memory Configuration in MS SQL Server
Understanding Memory Usage Lock Pages in Memory Min and Max Memory Setting
No process is on the other end of the pipe
Recently I got the below error when trying to connect to SQL Server. There error was caused in this case because the max memory setting was set to […]
Database in Suspect: – DBCC CHECKDB – It has been marked suspect by recovery
A database on the server was recently in suspect mode and the error message below was provided on running DBCC CHECKDB. This is a classic case of why […]
Memory for Servers – Hardware
Most database administrators are at least to some extent familiar with what memory does for SQL server. This is especially true for scenarios such as configuring minimum memory in maximum memory, checkpoint, lazy […]
Managing inventory in SQL Server –Part 1
A fairly important aspect of retail software is inventory management. Often this requires some kind of counter that reduces the count of stock items based on the number […]
When does SQL Server Cache an execution plan?
Ever wondered under what circumstances SQL Server cache an execution plan. What is the difference between simple and forced parametrization. What are the disadvantages of plans being cached? […]
3 settings to improve SQL Server performance
There are a number of dials and knobs in SQL Server that allow the DBA to fine tune almost every aspect of the server. In this post I […]
Tuning SQL Server using Fill Factor to control page splits
Is it better to take a hit on performance due to Fill Factor or Page Splits? That is the question being answered in this video. As with most […]
Why you should continue to defrag your indexes:-What are page splits 1/4
Recently I came across a video in which it was suggested the Page Splits/sec counter was not useful in identifying Page splits and that using fill factor to […]