Browse by Tags

All Tags » General Tuning (RSS)
18 February 2010 15:56

If you have Enterprise Servers you should read this blog

I feel that a DBA should have a good working understanding of the underlying server that SQL Server sits upon and the storage system(s) that it connects to, otherwise you may not know if you're being spun a yarn when you're trying to understand...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
30 March 2009 21:35

Parallel Worlds or slipped reality?

I’ve been planning a post on the subject of parallelism for some considerable time but the inability to be able to present reproducible tests for illustration had been a major concern. Things change however, I picked up on an interesting post  http...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
19 March 2009 20:39

How to determine that hardware DEP is available and configured on your computer

Well here we are again with another post I’d been saving up until I resolved the images issue. DEP and how it affects memory on your SQL Server!!! Microsoft KB: 912923    MICROSOFT KB: 875352 ===========================================...
Posted by GrumpyOldDBA | with no comments
Filed under: , , , , , ,
18 March 2009 21:33

x64 Memory Problems

(  I’m hopeful that Livewriter will enable me to publish a blog post which includes screen shots as this one has a large number! ) Please READ everything and the documentation with the download before you install this I’ve blogged about memory issues...
Posted by GrumpyOldDBA | with no comments
Filed under: , , , , ,
16 March 2009 20:38

Reasons to move to SQL 2008 MERGE pt 2

In my previous post with the MERGE statement it was assumed that the pairs of data would be unique and the second set would not already exist. I can’t say that I’d actually put together a really good example and I’m not saying that this is the most brilliant...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
31 December 2008 15:40

CompareStorage@GrumpyOldDBA

As a slightly seasonal touch of lightness I though I’d just do a comparison of DAS and SAN storage Item DAS SAN Basic Storage Cost Good Hideously expensive Ease of Use Simple How many storage engineers and system administrators does it take to change...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: ,
31 December 2008 12:25

Testing Times 4 - 4 semiT gnitseT

Yeah I know it's a silly title but I decided to up my testing by mirroring the database that I populate, that way I can create havoc on two servers at the same time and get a feel for how mirroring might be of use to me in the future, or not. One...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under:
23 November 2008 22:31

Testing Times 3

( I was on holiday for three weeks so sorry for the delays ) In my previous posts I briefly mentioned the task in establishing a method to benchmark a SQL Server new build or migration. This hasn't been an easy task by any means and I am under pressure...
Posted by GrumpyOldDBA | with no comments
Filed under: , , ,
13 October 2008 15:28

Testing Times 2

Just sometimes it's possible to get to a position of not being able to see the wood for the trees. I'm indebted to Paul Randal http://sqlskills.com/blogs/paul who returned me to normality after one of those lapses of reasoning. You'll see...
Posted by GrumpyOldDBA | with no comments
Filed under:
07 October 2008 15:41

Testing Times 1

It's an interesting time with being asked to performance test/benchmark a new server setup for a migration of sql server and data centre. Both current and new servers are SAN attached and it has been what is effectively the testing of the storage...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: , , ,
18 August 2008 08:28

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 by GrumpyOldDBA | with no comments
Filed under:
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 | 3 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: ,
More Posts Next page »