Finding logspace in SQL Server using ‘dbcc sqlperf(logspace)’

We can find logspace of all databases in any SQL Server Instance, using  ‘dbcc sqlperf(logspace)’.

when you run dbcc sqlperf(logspace) on any SQL Server instance it shows all the database names, how much space is available in log file and how much space is used by log file, etc.

The following image tells clear information logspace on SQL Server.

sqlperf

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s