Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-07-20 : 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
38200 Posts |
Posted - 2010-07-20 : 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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-07-20 : 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
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-07-21 : 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
38200 Posts |
|
|
|
|
|
|
|
Capacity Planning