Browse by Tags

All Tags » General Tuning (RSS)
10 June 2008 20:30

Tracking problem indexes in SQL 2000

It’s all so easy(ish) to work within SQL 2005 but the reality is that there are still more SQL 2000 databases than SQL 2005, so I’m told, and I’m supporting one of them right now. I’ve been contemplating on how to get a handle on which of my indexes are...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
03 April 2008 12:53

Disk Partition Alignment ( SANs and Diskpart )

As a further post to my series on what else can affect SQL Server Performance here’s the thorny issue of disk partition alignment. Disclaimer : I don’t get to configure SANs, places I work have dedicated teams and it’s unlikely a DBA would be considered...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
26 March 2008 08:02

Configuring x64 SQL Server

I often read a number of forum posts concerning performance / configuration issues with x64 SQL Server. I've also found some interesting views on how much memory you can allocate to SQL Server on a x64 install ( I don't have any experience of...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
25 March 2008 22:11

Do you really need those services?

As a continuation of my series of posts which look at Windows Server rather than SQL Server here's one about services. o When your SQL Server is under pressure stopping or disabling unnecessary services may free up resource. o This is especially true...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
12 March 2008 19:57

Things that may not be right on your SQL server.

Ø When performance is under the spotlight most often the finger is pointed at SQL Server, here’s a short list of things that may impact your server performance. Disclaimer : This is my personal hit list and in no particular order. Out of date drivers...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , ,
22 February 2008 20:34

dbcc dropcleanbuffers - or maybe not

As a consequence of another action I was prompted to want to clear the buffer cache – or to be more precise I tried to clear the buffer cache. So stepping back, what happens if you install more memory than the combined size of your databases? Most would...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
30 January 2008 19:18

Things I learned today

I'm involved with some tuning as usually tends to be the case and amongst the work I've been doing a couple of interesting points arose. Firstly we upgraded the memory in the production cluster, what was unusual for me was that we added more memory than...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,
24 January 2008 18:58

Perfmon Counters thresholds

Just in case you missed the link to The Premier's blog http://sqlblogcasts.com/blogs/thepremiers/archive/2008/01/23/monitoring-sql-server-using-performance-monitor.aspx they've just posted details of a perfmon trace viewer. But what is more important...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
10 January 2008 12:32

Tuning SQL Server configurations

One place to sometimes view configuration for SQL Server is the full disclosure documents for TPC benchmarks, yes I know I should get out more, however, it does sometimes make for interesting reading on exactly how some fantastic throughput is achieved...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
06 January 2008 20:41

Configuring Windows 2003 ( x64 ) for SQL Server

There is an almost constant stream of posts on forums asking about configuration of SQL Server 2005 memory, especially for x64 editions. Alongside these are also a number of posts concerning performance or perceived performance issues with x64 SQL Server...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , , ,
23 October 2007 18:18

How to monitor SAN performance

I was at the Storage Expo last week having a look around for SAN monitoring tools and to speak to a couple of vendors about their tools, yes I know you'll probably think " how sad " < grin > Storage performance can impact SQL Server database performance...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
27 September 2007 08:19

Analysing Indexes Part 4 - Size does matter - 3

11. dropping the clustered index shows all secondary indexes at + 9 bytes ( integer index replaced with guid index ) Index id index_typec Index depth Index level Page count Record count avg_record size_in bytes 0 HEAP 1 0 153847 2000000 579 datetime 2...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:17

Analysing Indexes Part 4 - Size does matter -2

4. Replacing the clustered Primary Key with a non clustered Primary Key on the integer column gives us two secondary indexes, each entry being + 9 bytes The primary key is index 3 Index id index_typec Index depth Index level Page count Record count avg_record...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
27 September 2007 08:12

Analysing Indexes Part 4 - Size does matter

( can't post this in one go so it's going to be a few parts ) v I’ll say now that this is a whole lot of figures and values, I’ve attempted to summarize what I can at the end of the article; for those who want to cut to the chase. o ( The naming used...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
24 September 2007 13:53

An update on the TokenAndPermUserStore “problem”

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2007/07/19/more-tokenandpermuserstore.aspx As the original incident had been raised on the back of an application service pack upgrade I made use of one of my msdn incidents. I have patch 3179 applied...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
More Posts Next page »