After having a few ideas in mind it was a tough choice of first post but went for sp_server_diagnostics a rather helpful stored procedure built into SQL. I've been putting it through its paces on a client site lately and it is really useful. Whilst it won't replace any of my usual methods like DMV scripts it's certainly a handy addition to the troubleshooting toolkit.
Here's the link:http://www.sqlshack.com/using-
No comments:
Post a Comment