SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Capacity Planning
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbalearner
Constraint Violating Yak Guru

269 Posts

Posted - 07/20/2010 :  20:37:26  Show Profile  Reply with Quote
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
37471 Posts

Posted - 07/20/2010 :  20:48:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

269 Posts

Posted - 07/20/2010 :  21:52:52  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37471 Posts

Posted - 07/21/2010 :  01:14:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
Well you need to track database growth over time so that you can predict when you'll need to add disk space, add data files, etc... I watch database growth via my tool: http://weblogs.sqlteam.com/tarad/archive/2008/12/16/How-to-track-database-growth-across-multiple-SQL-Server-instances.aspx

As far as capacity planning, you can watch PerfMon Counters over time to determine if you are running into capacity issues. Check CPU, memory, IO, and various SQL counters (buffer cache hit ratio, page life expectancy).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

269 Posts

Posted - 07/21/2010 :  18:58:56  Show Profile  Reply with Quote
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?

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37471 Posts

Posted - 07/21/2010 :  23:57:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
You can enable CLR via sp_configure.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000