Determine Space Consumed by each Table in a SQL Server database

Please see below query, which will help you to determine Space Consumed by each Table in a database


   
 


Query used as below:

       select  OBJECT_NAME(object_id) as objname

            , SUM (reserved_page_count) * 8192/ 1024 as reserved_kb

            , SUM(used_page_count) * 8192 / 1024 as used_kb

    from sys.dm_db_partition_stats

    group by OBJECT_NAME(object_id)

    order by reserved_kb desc
   

Comments

Post a Comment

Popular posts from this blog

Request failed with HTTP status 503 Server Error

Image
Problem: When 100's of users ae trying to access Reporting services report then, SSRS throws error as below : "Request failed with HTTP status 503 Server Error" and how to resolve this error Solution: From experience, this issue can be caused by multiple reasons Problem might be related to: 1 - TCP/IP Port Exhaustion: When a client initiates a TCP/IP socket connection to a server, the client typically connects to a specific port on the server and requests that the server respond to the client over a short-lived TCP or UDP port. The default range of short-lived ports used by client applications is 1025 through 5000. Under certain conditions, it is possible that the available ports in the default range are exhausted. 2 - If you are using any custom assembly method in any of your report (say for example PrivateFontCollection class or anything else), if yes then you might want to review that 3 - Change MaxActiveReqForOneUser from its default value o...
Read more

How to Troubleshoot Subscription issue in Reporting Services

Tips on troubleshooting Subscription issue in Reporting Services 1 – Look at the Reporting Services Log File Error Message from Log File: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   INFO: Notification 20f7b482-eb74-4b51-9e53-9f0609034e72 completed.  Success: False, Status: Failure writing file Startup :  The report server has encountered a configuration error. , DeliveryExtension: Report Server FileShare, Report: Startup, .......      2 - Run below query agains...
Read more

First hit to Reporting services is slow

Problem: First hit to Reporting services is slow Proposed Explanation and solution: This is because IIS is a demand-driven web server, i.e. IIS does things only when asked for. For example: an IIS worker process spawns up only when requests arrive for the sites that are hosted in this worker process. So when someone hit the reporting service for first time then it will perform some of the initialization activities such as: Initialization of data structures Loading data from a datastore into memory  (caching) Compilation of code, e.g. .NET applications Establishing database connections Recommendations: 1 – Spinning up an app pool can take some time and make the application less responsive so keeping them up for longer can help performance, so may be changing default recycle time from 720 min (12 hours) to 2880 min (48 hours) will help the performance 2 – Create and run simple scheduled report to keep SSRS active running every hour. For example: A simple ...
Read more