Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is there a tool out there that will go through a schema, compare the current values, and return a report of what columns are near the capacity of their data type? I am looking for a tool that can give me insight into limitations that may be reached soon. An example would be forewarning that I am at 60% of reaching the limit of an INT on a column).

share|improve this question
add comment

1 Answer

I don't know of a tool to purchase, but you could create a SQL job that could analyze things for you. I'd hoped that the Redgate software would do it, but that's pretty much for comparing schema of databases between servers (I suppose you could use it to find all the INT columns in all tables, but you can look that up yourself in system tables)

Have the script look at each Column you're concerned about and check its value against the max value. Use conditional statements that only send an alert when the value is relatively high.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.