DBCC Command

Question

Post reply

DBCC Command

Latheesh NK

SSCertifiable

Points: 6559
More actions
January 10, 2011 at 10:13 am

#388591

IS DBCC SHowFileStats undocumented reallt? Frommy understanding it is. However, I have seen in many of the appication related with the perormance monitoring, it is been used. What are your thoguths on the same? Can it be proposed for a production monitoring?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

parthi-1705 SSCrazy Eights Points: 9277 More actions · Answer 1

Hi,

Have a look at the below forums

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30218/

http://sql-server-performance.com/Community/forums/p/4438/29362.aspx

Thanks

Parthi

Thanks
Parthi

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 2

I have gone through the first link and understood that we should not go for master, tempdb etc. However, if we are seeing some issues on these databases, how do we ensure it would not be the same case as the user database? I am expecting clear answer that whether we canuse the ShowFileStats in production or not.

Please help me out on the same.

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 3

Appreciate if some one could help me out on the same.

Lowell SSC Guru Points: 323518 More actions · Answer 4

well, my two cents:

I have no problem using it for production or anywhere else. It exists in 2005,2008/R2 and Denali/V11 as well... so anything I incorporate using that would have a minimum usable lifespan of, what, at least eight to ten years.

Additionally, since it would be incorporated in easy to update jobs and scripts, and not buried in some executables codebase, it'd be a lot easier to update if the code needs to be improved, tweaked, or even replaced.

Saying it's not officially supported just needs to make me aware that i might need to update a process in the future... not treat it like COBOL, and ignore it for 30 years until the SQL equivalent of Y2K comes around.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!