Monthly Archives: September 2008

More database performance tuning.

Cleaning up extra indexes, and implementing parameterized queries. I don’t know how many times I have had to explain the difference between a clustered index and a non-clustered index.  In the end it is all good. Better performance, faster software,

Posted in Performance

Query SQL Server 2008 Total Memory Usage

The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But

Posted in DBA Tagged with: , , , , , ,

How much Procedure Cache memory does one SQL Statement take up?

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between

Posted in DBA Tagged with: , , , ,

Database Tuning at Emergency Reporting

This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server database performance.  Fun stuff.

Posted in Performance Tagged with:

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions