Browse by Tags

SQL Versions Performance Benchmarks

http://sqlblog.com/blogs/joe_chang/archive/2008/08/17/large-query-performance-from-sql-server-2000-to-2008-32-64-bit.aspx Joe has published a well readable article.

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 08-18-2008
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 fragmenting too quickly and where the high levels...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-10-2008
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 a reference point regarding storage. What I can...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-03-2008
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 ia64 - sorry ). Sort of cross purposes I've been...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-26-2008
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 of x32 systems where bottom memory allocation...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-25-2008
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 Look mainly for HBA, NIC and storage controllers Incorrect...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 03-12-2008
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 probably suggest that it’s a waste of time, however...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 02-22-2008
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 we had databases, I've never worked a production...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-30-2008
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 is the attached documentation on perfmon counters...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-24-2008
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 in a test environment. I'm still researching x64...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 01-10-2008

Page 1 of 3 (26 items) 1 2 3 Next >