October 21, 2008 at 7:12 pm
Hi,
I am trying to find out the log space usage for all the databases on the server. I used to use DBCC SQLPERF(LOGSPACE) command before, but DBCC became deprecated in the new version of SQL Server and I want to start using a newer alternative. Is there something similar except 'sys.database_files'? I can't use sys.database_files because it does not show all the information DBCC SQLPERF(LOGSPACE) shows.
Thanks.
October 22, 2008 at 1:38 am
DBCC SQLPERF(LogSpace) isn't deprecated in SQL 2008. There's no deprecation notice in BoL and running it doesn't fire a deprecation event for profiler to pick up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2008 at 12:11 am
This is good news. I've been on SQL 2005 Performance course and they mentioned that Microsoft gets away from DBCC commands towards DMVs, and DBCC will eventually disappear. I was under impression that every single DBCC command is now deprecated.
Thanks.
October 23, 2008 at 7:58 am
Roust_m (10/23/2008)
I was under impression that every single DBCC command is now deprecated.
Some of them (showcontig, index defrag, etc) are deprecated, however there are a large number still fully supported within the product. Including SQLPERF, CheckDB (and the assorted other Check commands), Traceflag-related commands, cache-related (DropCleanBuffers, FreeProcCache, etc) and a collection of others
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply