I guess you'd need to read the event log into a table and scan the table and then raise an alert from that.

yeah no easy feat! I have code which will clone a user or set of users but only to role level, not to object level. Best of luck!

yup did the maths too - but is 2gb / sec ( through awe ) a bottleneck ? It's the usual problem with perfmon counters - there's often just...

if you have sufficient memory on an x64 box you can run without a page file.

no experience with your question but I'm interested as you mention lengthening the checkpoint, which is something I posted about as I'd read some time ago you can use this...

If you rebuild a table with a clustere didnex you'll probably need 1.5 times the size in the t log. You could build yourself a fast tempdb and do the...

yup, that's what I figured as despite my best efforts I couldn't seem to find any way to calculate this.

I have a hunch that around 270k/sec is the best value...

http://www.grumpyolddba.co.uk/infrastructure/HP%20Lights%20Out.htm

there is no lock pages for std edition. Make sure you set min and max memory on the sql server. I've posted a series of posts about o/s and x64...

there's a link on my blog I posted today

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/04/03/disk-partition-alignment-sans-and-diskpart.aspx

Yes I have looked at HBA buffers, tricky one as usually you don't get given time to test, I had mine set...

I have to admit it's not something I use very often - something esle to investigate!

These are typical values, in reality you'd probably be lucky to get 80% of these values.

so your raid 5 x 5 spindles would support ((5 * 174 ) *...

raid 5 ( or 6 ) is only any good for a read only database, you should be capable of getting around 1000 io for reads but only around 250...

I usually make sure I set the rollover to around 250mb - 1gb depending upon activity. The easiest is probably to load into a table although you'll need a lookup...

I wrote an article which was never published a few years ago which covers some of this. It still holds true in sql2005, I've never found issues with capitalisation of...

I'll add your question to my list of things to test, assuming i can figure out a reasonable test that I can repeat.