I have two local DNS/AD DC i pont my cluster nodes at. they are for example dns1 and dns2, when they rebuild these to Windows 2008 r2, they will keep...

Thanks guys,

Correct domain is being upgraded. they have already started replacing the 2000 AD DNS/DC with 2008 r2 DNS/DC. They advised the two dns/DCs i point my cluster at will...

You might find this helpful.

http://www.brentozar.com/archive/2012/12/bob-dylan-explains-tempdb-video/

We are already doing nightly full backups. without this we would be in hot watewr over writting the log backups everyday. we also archive the tlogs and nightly backups to...

You realise that if the one SSD fails you're SQL Services will fall over. While all you'll need to do is replace the drive bring it online with the same...

Problem is that the files will just build up if the filenames are different. This current setup allows the files to just roll over the next day.

That works thanks. but it puts the whole data and time on the file name.

Is there anyway to just get the time?

Are apparently a few new reports where run and the user accidently set some filters wrong so alot more data was pulled than should have been. the report has been...

Well the issue has not happened again.

I did get some feedback from one of our report writters that they were testing a new large report at that time. I'd say...

I've sent an email to all our report writers, reports are written in Crystal. so i'd expect the queries are hardly optimised. problem is becuase it's the start of the...

Could your second point be caused by a "hero report writer" :)?? the server has been humming alot fine for almost 3 years then this suddenly yesterday.

Thanks for the tips.

Memory pressure,

The server has 32GB of RAM, 28GB is assigned to SQL server as MAX memory. TempDB is presized to 10GB (app vendor best prac). The user...

Yep I've asked the app admin and report people everyone is claiming they were doing nothing.

All the users access the DB via the application front end. So general users shouldn't(wouldn't)...

I personally wouldn't use 12 disks in a single raid 5 array, recently i've used Raid 50 for similar sized arrays, basically it's creates two 6 disk raid 5 arrays...

I'm not good with AD but an issue i had was that during the install despite the domain service account used for the cluster having the right to create AD...