Browse by Tags

All Tags » performance (RSS)

Reducing Deadlocks - not a DBA issue ?

As a DBA, I'm involved on an almost daily basis troubleshooting 'SQL Server' performance issues. Often, this troubleshooting soon veers away from a 'its a SQL Server issue' to instead become a wider application/database design/coding...
Posted by steveh99999 | with no comments
Filed under: ,

SSAS - What is running ?

I saw a tweet today from respected blogger john sansom asking how a SQL DBA should attempt to performance tune SSAS. I've been through a similar scenario - and one of the tools I developed as part of my troubleshooting was my own 'SSAS version'...
Posted by steveh99999 | with no comments
Filed under: ,

Auto Update Stats change in SQL 2008 R2 sp 1

I came across a very interesting post via Brent Ozar’s weekly news email – ( I strongly recommend you go to Brent's excellent website and subscribe to the weekly update) The post states that a new trace flag had been made available in SQL 2008 R2...
Posted by steveh99999 | with no comments

Do you send output from sys.dm_exec_query_stats to your developers ?

A few years ago, I had the good fortune to work on an engagement with Kevin McPherrin of Microsoft. Kevin is one of those Microsoft employees that you never hear about, but is an absolute expert on DBA good-practice and SQL advice. One really useful tip...
Posted by steveh99999 | 2 comment(s)
Filed under:

Every DBA should read this..

Came across a very interesting article recently whilst reading a Joe Celko  blog and Tony Rogerson comment.  Although it’s not directly related to SQL Server,  and is a few years old now, I think every DBA should read this – here
Posted by steveh99999 | with no comments
Filed under: ,

WHERE x = @x OR @x IS NULL

Every SQL DBA and developer should read the blog of MVP Erland Sommarskog – but particularly  his article on dynamic search conditions in T-SQL . I’ve linked above to his SQL 2005 article but his 2008 version is also a must-read. I seem to regularly...
Posted by steveh99999 | 1 comment(s)
Filed under:

Too much I/O in the morning ?

Interesting little improvement on a SQL 2005 system I encountered recently….. Some background - this system had a fairly ‘traditional OLTP’ workload ie heavily used during day – till around 9pm, then had a batch window for several hours, then not much...
Posted by steveh99999 | with no comments
Filed under:

DBCC MEMUSAGE in 2005/8 ?

I used to like using undocumented command DBCC MEMUSAGE in SQL 2000 to see which tables were using space in SQL data cache. In SQL 2005, this command is not longer present. Instead a DMV – sys.dm_os_buffer_descriptors – can be used to display data cache...
Posted by steveh99999 | 4 comment(s)
Filed under: ,

My first blog post…

I’ve been meaning to start a blog for a while now, (OK, for several years…..) - finally now, here it begins First post, something really simple but, a wise-man once told me about the best way to improve SQL server performance. Store Less Data. That's...
Posted by steveh99999 | 3 comment(s)
Filed under: