get hold of 'Troubleshooting SQL Server - A Guide for the Accidental DBA '

by Jonathan Kehayias for how to track these values.

It will be thorough a mixture of...

I would have thought senior management would be interested in throughput figures - so disk latency, disk sec\read, disk sec\write, response times for queries (end to end), what percentage are...

which gives me an idea, grow the files a bit see if the modify dates change.

berniesprouster (5/19/2014)

---

I was just hoping that there would be a way of issuing some kind of checkpoint which may result in the modified date of the ldf file updating, and...

so you have run alter database but wish to check the database has actually been bounced? First of all don't get into that situation 🙂

If the database was not down...

I find that if I have a profiler trace representative of normal activity the queries are fairly obvious if you search on the table name, the more so the higher...

thanks djj, but all the values I require (including hostname) are in sysprocesses so thats all I need for now on pre 2012 systems.

you could check sysfiles within each individual database, or use virtualfilestats DMVs to see where the activity is going to (values will change between runs)

cheers, I have a plan of action now and we know where we stand with current DMVs and those from 2012 onwards.

george

looking at sp_whoisactive I could of course just use it as it is to achieve what I want, but it would be overkill!

I am pretty sure Adam is joining back...

thanks for the reply Grant.

Adams code is still referring to sysprocesses in the SQL2005 and 2008 compatible version so there still seems to be a need for it (although to...

thanks, and thanks once again for the article.

Its nice that this feature is included in the standard edition as well.

Perry,

yes thats the scenario.

Above the line 'When restoring the certificate backup, if you wish to encrypt by password, uncomment the line above.' - there were no comments in the code...

Perry, thanks for the article.

If you have a test server on which you may restore backups from multiple prod servers how is that handled? Do you need to copy down...

I feel your pain. Show them the errors and how it is tying in with slow application response and blocking. They absolutely have to check out their hardware and firmware.