I am running a shrink job on SQL Server 2005 and the database called TempDB became massively huge as in over 200 gigabytes. I just started a shrink job on the database, so how long will this take before this finishes?
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a discu…
Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question.
*Log into your Experts Exchange account
*Find the question you want to Request Attention for
*Go to the e…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg).
If you're interested in additional methods for monitoring bandwidt…