Thanks Colin, this was my concern and exactly what I was leading to...but wanted to clarify first.

Tracey,

I tend to only use such MS tools as SQLIO, SQLIOStress, and the...

Tracey,

You mention an MS IO tool and that you use it to see the status of your IOs.

What MS IO Tool do you use, and when do you use it...

I think theSQLGuru has touched on the right area. Worth looking at the following which may explain this:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/22/956.aspx

Also useful to note the effect...

Hi karthikeyan,

What the formula is doing is compounding the percentage growth of 2% per month for 36 months.

So, if your database is 600 GB, then after the 1st month...

Hi Marcus,

Got a few questions to see if I can be of any more help:

Do you know if the indexes you have are being used? 

How is the data population...

Marcus,

My view would be to test and see (if possible). From that you will get the answer.

[Ed] A while ago I would have agreed with you re: use clustered indexes...

[Hi Kevin] If you mean by semi-static that, say, in a DSS DB where the data is imported during the night and during the day when reports/scripts are run, that...

I've read this with great interest and agree with a lot of what some people have said, and disagree with a number of others.

I tend to be in the camp...

Hi John,

might be worth looking at this MS WebCast :  http://support.microsoft.com/kb/895614

Found it very useful for setting up our SANs. We know that what David G Brown suggested has worked because,...

Hi Chris...

Can't argue on the DAS setup you put forward. For tlogs you always want to go for the best possible write performance, as thats what tlogs are going...

DBA_Rob...wasn't that our disks weren't managed well, replacements were put in very quickly (and yes we had hot-spares too), the issue was more to do with the h/w guys having...

Sorry justinb486, but I am going to have to disagree with your comment that a SAN basically negates the entire RAID issue. This has come from experience of having worked...

We try and use RAID 1 / 10 wherever possible. Rarely will we submit to RAID 5. Why? Because, it has limited redundancy - if you lose one of the drives...

Ok,thanks Pavan. Glad its sorted.

Mohammed, I was asking if Pavan had tried a restart before running the script to see if SQL Server was able to rebuild tempdb in the...

True Eric, but IMHO that's not the specific question Bowled23 is asking, and I'm sure that the author will want to know what caused this growth.