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 to use for support I had to rely on Perfmon, sysprocesses and the usual old […]
Category: SQL Tuning
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 currently in use. For this client I had presented the expected IOPS per type of […]
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. This was good stuff so far, then the author stated that these can be changed […]
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 size of the file this can be a very time consuming task. By turning on […]
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 size of the file this can be a very time consuming task. By turning on […]
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 on security and then check the proper radio button. When putting together or most recent […]
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 few simple steps or accomplish it with TSQL. To make this change with SSMS, open […]
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL Index Manager. This tool is aimed at the accidental DBA or for those like me who are just lazy. 🙂 It is basically a nice GUI to return your index fragmentation level and makes a […]