Hi, Can somebody give direction on the following please. I wish to quantify workload and throughput of my SQL Server box containing one user database and want to make a statement like "The throughtput of my server is X and the workload is varying between Y and Z within last 3 months. Based on the current trend in workload we need to think of additional resources in W months". Is this possible with perfmon counters data collected historically? Thanks in advance of any response.
I believe Quest software has the tool.... Capacity planning and trend analysis or something this... And also check the following articles... http://www.sql-server-performance.com/articles/per/trend_analysis_performance_monitor_pt1_p1.aspx
Hi Mohammed, I have already evaluated this tool and in a process of buying it. The question is coming to my mind, what is the logic and counters they may be using? I won't be able to get a tool for each customer.. what is the principle governing measurement of the workload? I have figured out how to quantify the throughput. Thanks.
Do you have the complete idea on the business of your organisation? If so it will be easy to perform the capacity planning of the database instance, to me the best way to determine future storage needs is to analyze the past with an eye out for potential business changes that cannot be reflected from historical calculations. Further to this I'm quoting the references from the web resource that: "All businesses change and therefore those applications change as well. Some applications are retired while others are brought into the production environment". On a related, if you know you are bringing on a new customer that is going to double the revenue for the organization, odds are that you are going to have to plan for this storage. Links to plan further: Determine Free Disk Space in SQL Server with T-SQL Code Determine Free Space, Consumed Space and Total Space Allocated for Microsoft SQL Server databases
