Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

capacity planning for SQL Server Dbs storage Expand / Collapse
Author
Message
Posted Sunday, February 21, 2010 7:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:38 AM
Points: 93, Visits: 496
Hello All,,

I am tasked to provide the storage required for SQL Server Databases for the coming 3 years
I followed some instructions I have found and collected the data required to complete my task
Like

• How many database will host on SQL server
• How many users connected to SQL SERVER
• Row length per table for each database
• Data loading rate per day\week\month
---------------------------------------

On the time being I am searching on an easy way to calculate the storage required for the coming 3 years based on the input I have.

Does anyone have an idea or clear and solid steps to do this??

Thanks in advance & appreciate ur support
Post #869838
Posted Sunday, February 21, 2010 4:11 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
FYI: this is actually called "Storage Planning", as "capacity planning" has a very specific and completely different meaning for computer systems.

I do remember seeing some good storage planning articles a couple of weeks ago, I'll see if I can find them...


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #869968
Posted Sunday, February 21, 2010 4:13 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
also, what kind of organization is this for? Business, academic, non-profit, Govt, NGO, ... ?

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #869969
Posted Sunday, February 21, 2010 5:03 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
This isn't the article I was thinking of, but it does have some perspective and approach for this: http://sqlblog.com/blogs/merrill_aldrich/archive/2009/10/29/using-historical-perf-counters-for-storage-planning.aspx

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #869976
Posted Sunday, February 21, 2010 6:18 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:56 PM
Points: 987, Visits: 1,634
I guess you could find out the storage required for data using the data load rate, then double it to account for indexes and then double it again to account for any underestimation you could have made.


Post #869983
Posted Sunday, February 21, 2010 6:58 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:53 PM
Points: 33,063, Visits: 15,179
Are you "loading" data or is this users making changes? If it's the latter, which is what most systems have, it's impossible to do anything other than guess without historical data.

I've typically used backup sizes (since those are data) and tracked that over time to allow me to extrapolate out what space I will need in the next xxx months.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #869993
Posted Monday, February 22, 2010 3:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:38 AM
Points: 93, Visits: 496
thx guys

here is how to Determining SQL Server database storage requirements in 2 ways Hard and easy


http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1289528_mem1,00.html

thx again
Post #870184
Posted Monday, February 22, 2010 7:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:53 PM
Points: 33,063, Visits: 15,179
That's a highly incomplete link, and it's what was said before.

The hard part is determining
- records/month

If you know that, then it's easy. But getting that number can be very hard.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #870359
Posted Monday, February 22, 2010 8:03 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:38 AM
Points: 93, Visits: 496
I guess this info supposed to be available with applications developesr and business users, the only way to get this number is "Expectaion " , coz no way provide exact number for record per (day,week or Month) for a blank farm

Kindly correct me if i am wrong



Post #870373
Posted Monday, February 22, 2010 8:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:10 PM
Points: 2,826, Visits: 8,463
I don't delete my full backup history so that I can use previous backup size to predict future growth.

-- Average DB size by month for ALL Databases
-- Backups DO NOT include free space in database

select substring(a.database_name,1,35) as 'Database',
datepart(year,a.backup_start_date) as 'year',
datepart(month,a.backup_start_date) as 'month' ,
avg(cast((a.backup_size /1073741824) as decimal (9,2)))as 'Avg Gig'
FROM msdb.dbo.backupset a
join msdb.dbo.backupset b on a.server_name = b.server_name
and a.database_name = b.database_name
WHERE a.type = 'D' and b.type = 'D'
--and a.database_name = 'xyz'
and a.backup_size > 1073741824 -- > 1 Gig
GROUP BY a.database_name,datepart(year,a.backup_start_date),datepart(month,a.backup_start_date)
order by a.database_name,datepart(year,a.backup_start_date) desc,datepart(month,a.backup_start_date) desc




Post #870391
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse