Category Archives: SQL Tuning

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I support.  In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter … Continue reading

Share
Posted in PowerShell, SQL Tuning, SQLServerPedia Syndication | 1 Comment

What is Page Life Expectancy (PLE) in SQL Server

Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know that a quick look at perfmon or task manager can tell us of high CPU usage, but what is a … Continue reading

Share
Posted in Query Tidbits, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

Performance Impact from Page Splits

Recently I was brought in to help troubleshoot performance issues on a database server.  Going through my typical check list I noticed memory pressure on the box and made the recommendationof more memory which was simple to fix. What caught … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 8 Comments

When Things That Are Supposed to Protect You Try to Kill You

This past week I was presented with a very unique issue.  A call came in with a production issue on a tier one application.  Unfortunately it was on a system that utilizes SQL 2000 SP4.  Having a rather small toolset … Continue reading

Share
Posted in Backups/Recovery, SQL Tuning, SQLServerPedia Syndication | Tagged , | 3 Comments

IOPS versus Throughput – Measuring Performance of Your Storage

Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s versus IOPS as I had recommended a storage array that would provide many more IOPS and throughput than what is … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 3 Comments

File Extensions for SQL Server Database Files

I was reading an article over the weekend where the author pointed out that the standard naming convention for SQL Server database files was .MDF for the data file, LDF for the log file and NDF for additional data files. … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 3 Comments

Turn on Instant File Initialization for SQL Server Performance – With Video Demo

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | Tagged , | 9 Comments

Turn on Instant File Initialization for SQL Server Performance

Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or has to grow in size, the file or portion of the file added must be zeroed out.  Depending on the … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication | 1 Comment

SQL Server Login Auditing

In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins.  It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication, Tibits | 6 Comments

Increase SQL Server Error Log Files

Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance of SQL Server maintains.  This is real simple to change.  You can make the change via the GUI with a … Continue reading

Share
Posted in SQL Tuning, SQLServerPedia Syndication, Tibits | 5 Comments