After clicking disk usage report of the database, it's showing "Retrieving Data" for very long time... and nothing comes out. Is it normal or any other way to show that thanks.
MSSQL 2005 Management studio disk usage report
Hello all,
After clicking disk usage report of the database, it's showing "Retrieving Data" for very long time... and nothing comes out. Is it normal or any other way to show that thanks.
After clicking disk usage report of the database, it's showing "Retrieving Data" for very long time... and nothing comes out. Is it normal or any other way to show that thanks.
MSSQL 2005 Management studio disk usage report
kcchesnut
I'm sorry to hear that the report is running slowly for you.
I have a few questions for you:
1) Does the Disk Usage report run slowly for each database on your server instance or does it run slowly for a specific database
2) Are you running against a local instance or a remote instance
3) Do other Management Studio reports function normally
I would like to put together a series of blog posts on the Management Studio reports. I will describe how they are useful and what queries they execute. I will even try to provide an .rdl file in English so that you can modify them and run them in your SQL Server Reporting Services environment.
Check for this series in my team's blog in early May 2006 - http://blogs.msdn.com/sqlrem/.
-Paul