How to get all statistics information for a database in SQL Server

Spread the love


Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics to create query plans. Updated statistics will give you good performance.

To get the statistics information for a particular database, you can use the below script. You can update the statistics by using the below stored procedure.

exec sp_updatestats



SQL Database statistics
SQL Database statistics

Spread the love
Soyeluddin Biswas, SQL Server DBA. Mostly involved in Data center migration. He has rich experience in SQL server design and database migration.

1 thought on “How to get all statistics information for a database in SQL Server

  1. You have a very nice website, but I’m sure it’s pretty hard to find new article ideas and create content especially nowadays when it seems like all topics have been covered by someone..

    I’m sure you’re tired of getting these messages through your contact form, and that’s why I won’t bother you with long texts. I just think that you’ll have a lot to gain from this small tip:)

    I have been able to create articles easily for all my websites and avoid any duplicate content penalties from Google using a very smart and intuitive article spinner called Spin Rewriter, which I`m sure would work wonders on a business like yours. And the best part is that you won’t even need to know English as your main language. The strong AI behind Spin Rewriter will create articles in perfect english in minutes. Check it out and tell me what you think.

    You can reply to this email to ask for samples of websiteswhere we publish the content written by Spin Rewritter

Leave a Reply

Your email address will not be published. Required fields are marked *