Capacity Planning - Mostly disk usage- Tool

Question

Capacity Planning - Mostly disk usage- Tool

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
May 14, 2012 at 3:03 pm

#268867

I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool that in house development. I am looking for:
i) Should be able to report db growth per week
ii) Forecast report on storage
iii) good to have similar report for memory.
If anyone knows a good tool which can serve this please let me know.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 1

Have you had a look at RedGate SQL Monitor or the Idera products?

They both provide a good set of admin tools for reporting of disk, CPU and memory but I'm not sure about the forecasting.

My current flavour of the month is the RedGate tool although I'm always tempted by anything new that comes along.

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

Robin Sasson (5/15/2012)
Have you had a look at RedGate SQL Monitor or the Idera products?
They both provide a good set of admin tools for reporting of disk, CPU and memory but I'm not sure about the forecasting.
My current flavour of the month is the RedGate tool although I'm always tempted by anything new that comes along.

We have SCOM for monitoring, i am more interested in looking at the trend and do some forecast.

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 3

sqldba_newbie (5/14/2012)
I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool that in house development. I am looking for:
i) Should be able to report db growth per week
ii) Forecast report on storage
iii) good to have similar report for memory.
If anyone knows a good tool which can serve this please let me know.

Since your handle has "newbie" in it, increase your knowledge of SQL Server by writing your own. Seriously!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Jeff Moden (5/15/2012)
sqldba_newbie (5/14/2012)
I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool that in house development. I am looking for:
i) Should be able to report db growth per week
ii) Forecast report on storage
iii) good to have similar report for memory.
If anyone knows a good tool which can serve this please let me know.
Since your handle has "newbie" in it, increase your knowledge of SQL Server by writing your own. Seriously!

Good advice - especially if you are looking to really get to know the product.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 5

Jeff Moden (5/15/2012)
sqldba_newbie (5/14/2012)
I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool that in house development. I am looking for:
i) Should be able to report db growth per week
ii) Forecast report on storage
iii) good to have similar report for memory.
If anyone knows a good tool which can serve this please let me know.
Since your handle has "newbie" in it, increase your knowledge of SQL Server by writing your own. Seriously!

Honestly speaking i do but i don't think it is worth for the company on paying to a employee Vs purchasing a tool.

sfallen SSC Veteran Points: 293 More actions · Answer 6

Full-disclosure up front: I work for SQL Sentry, a tools vendor.

If you are looking for a third party tool, as suggested previously, performance monitoring tools are going to be where you find the functionality you are looking for. I understand you already have SCOM in place for general monitoring, but I think you will find as many of our customers have that a dedicated SQL Server tool adds a great deal of capability that SCOM does not easily provide, even with the SQL Server Management Pack. SCOM also compliments a dedicated tool like those we and our competitors offer by monitoring areas of the environment that are out of scope for a dedicated SQL Server performance tool.

Using a tool to analyze long and short-term usage trends can be a great time saver, but take care not to rely on "forecasting" features too heavily, as no tool can really predict accurately the business cycles and changes that may have dramatic impacts on your storage needs. For example, your monitoring tool won't have any clue that the new product you just launched was a huge hit so the order track database is going to grow at a faster rate than the previous trend. Forecasting tends to be as simple taking the average slope of the line and projecting it past the current time, pretty much the equivalent of laying a ruler on your screen.

Try out some tools, SQL Sentry as well as most if not all of the other offerings on the market all offer free evaluation licenses.

Good luck with your search and feel free to let me know if you have any questions.

-Scott Fallen

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 7

sqldba_newbie (5/16/2012)
Jeff Moden (5/15/2012)
sqldba_newbie (5/14/2012)
I did come across few articles related to capacity planning but couldn't find something what i was looking for. I am more inclined to buy a third party tool that in house development. I am looking for:
i) Should be able to report db growth per week
ii) Forecast report on storage
iii) good to have similar report for memory.
If anyone knows a good tool which can serve this please let me know.
Since your handle has "newbie" in it, increase your knowledge of SQL Server by writing your own. Seriously!
Honestly speaking i do but i don't think it is worth for the company on paying to a employee Vs purchasing a tool.

Don't think so short term and don't cut yourself short. Having a more knowledgable employee is always worth it to the company. The things you'll learn about SQL Server in doing this "simple" task can and will be applied to many other areas and add great value to the company. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)