| Author |
 Topic  |
|
|
dbalearner
Posting Yak Master
238 Posts |
 Posted - 07/20/2010 : 20:37:26
|
I have some queries regarding the capacity planning being administered.
Let me know whether these expressions related to the databases.
When I execute, I do get the Current Size to the Original Size -> if so, do I need to get that correct to the original size or what would be the impact?
The Growth Amount of data size is the size which has been grown, if so, what are the aftermath implications and measures needs to be amended; also with what measures need to adhere therafter to the individual databases?
Is there any other possible scope for getting the Capacity Planning?
I have executed through a SP which is good for 2000 Environment, will it holds good for the 2005 as well?
If not, can someone help me in getting me this correct.
Thanks all who participate here.
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
Posted - 07/20/2010 : 20:48:13
|
I don't understand your post, specifically these:
quote:
When I execute, I do get the Current Size to the Original Size -> if so, do I need to get that correct to the original size or what would be the impact?
The Growth Amount of data size is the size which has been grown, if so, what are the aftermath implications and measures needs to be amended; also with what measures need to adhere therafter to the individual databases?
As far as a stored procedure that works good in a 2000 environment, it may or may not work in 2005. You should run the Upgrade Advisor tool against the database, which will check many things including stored procedure code. But you should consider jumping straight to 2008 at this point as 2005 is a few years old now. There isn't a big change from 2005 to 2008, so you should be able to go to 2008 if you were considering 2005.
Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
 |
|
|
dbalearner
Posting Yak Master
238 Posts |
Posted - 07/20/2010 : 21:52:52
|
Thanks for responding...
The Original Size is dated back to the database size at its creation time and the Current size when I got now, the size of the database.
Now, when I see that 'growth in size' what are the implications wil arise hereafter and what should be the corrective measures as a result of this capacity planning.
As you have indicated need to look towards into 2008 which is closer to the 2005 environment, its the organisation's server and management needs to take the initiative, as I am just custodian for these servers and instances.
On the otherhand, Is there any Stored Procedure or Alternative method to adopt to get the Capacity Planning Measures?
Thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
dbalearner
Posting Yak Master
238 Posts |
Posted - 07/21/2010 : 18:58:56
|
Thanks Tara.
I dont have on my Server with CLR is administered, never applied also. Tested on Test Server but no result, may be I need to install for the CLR to adhere.
Any clues to do if I dont have the CLR absent on the server?
|
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
Capacity Planning
