This is a blog about stuff I come across as a DBA; fun stuff, hard stuff, weird stuff...just the random day to day stuff that I encounter.

Thursday, April 21, 2011

Getting Object Counts

Recently I was reporting a bug I noticed with a 3rd party tool, the support group asked me to send them "the number of instances, number of databases per instance, total number of tables and total number of indexes." Now I knew the number of instances I was monitoring, and I knew the approximate number of tables (perhaps a good DBA should know this number, not sure...do other DBA's out there with larger servers know the exact number? comment below, I'm interested), but I had no idea how many indexes. So I wrote a little script to give me this number and as I like to do, I'm making it available to the community, hope this helps you...if you find use of it (even years in the future) post below.

No comments:

Post a Comment

About Me

Hello, I'm a database architect with a background in software engineering and website design. I have been working with Databases since 2000, and specifically as a DBA since 2005. In my off time, I enjoy geocaching (high tech treasure hunting), and Scouts.