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 12»»

Analyzing Disk Capacity for SQL Server Expand / Collapse
Author
Message
Posted Wednesday, June 21, 2006 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 24, 2006 12:29 AM
Points: 13, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/aBanerjee/analyzingdiskcapacityforsqlserver.asp
Post #289114
Posted Wednesday, June 21, 2006 11:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 21, 2006 11:34 AM
Points: 1, Visits: 1
Its one of the most helpful articles I've ever came across.Thanks Arindam
Post #289153
Posted Thursday, June 22, 2006 5:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 24, 2006 12:29 AM
Points: 13, Visits: 1
Thanks Angshu. I will be posting more on capacity management. Please look around for more on this
Post #289301
Posted Tuesday, July 04, 2006 6:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 10:04 AM
Points: 585, Visits: 53

Not too bad at all, it definately covered the normal user requirements

Unfortunately our system is growing at geometiric rates (was 10GB a week last year), now 20, with occasional blips up to 40-50GB.

It's a little worrying when you buy an extra 4TB of storage and expect to have to get more by christmas next year, but at the same time it's also exciting, which is why i still love this job so many years into it.

Post #292017
Posted Tuesday, July 04, 2006 8:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 27, 2010 8:38 AM
Points: 236, Visits: 99
what would be intersesting for would be how you would best partition your filesystem - how do marry the best practice of separate disks and channels for tempdb, data files, transaction logs, OS, backups and pagefiles when you typically only have 2 channels and rarely more than space 9 physical disks per server.


Post #292029
Posted Tuesday, July 04, 2006 11:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 24, 2006 12:29 AM
Points: 13, Visits: 1

Thanks for the responce, firthr. I would love to research on your mentioned topic and see  whether I could get something to write on. Thanks for your input

~Arindam.

Post #292049
Posted Tuesday, July 04, 2006 11:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 24, 2006 12:29 AM
Points: 13, Visits: 1

Thanks for the responce! You are exactly right in your opinion. Certainly we could find out new rules and formulae, but every problem comes out to be a new one

I love this job too. Hope you could cope up with the geometrical growth!

Post #292050
Posted Wednesday, July 05, 2006 1:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 10:04 AM
Points: 585, Visits: 53

Yep, we're coping quite well, our SAN is more than up to the job so long as we keep adding extra storage and partitioning the data properly.

I might get round to writing an article on what we did in the hopes that it helps others, but it might be a while as I'm currently way too busy

Post #292111
Posted Wednesday, July 05, 2006 3:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 24, 2006 12:29 AM
Points: 13, Visits: 1

I will be eagerly waiting to see something on that

Write your experience and how you came up with a solution. That will be interesting.

~Arindam.

Post #292135
Posted Wednesday, July 05, 2006 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:38 AM
Points: 148, Visits: 652

I'd call this "Disk Management 101", in that it covers the basics.  I'd say the majority of the people in this forum already have implementation plans for storage capacity planning.  I was personally really hoping to see more about External Capacity...  can we expect one of those in the future, too? 

Given the above, SQL Profiler, and a good trace template, I have found it quite easy to point out Internal (SQL-object based) performance problems.  But what about those problems not associated with I/O?  Is it a Network Problem?  Client problem?  I have theories about the problems that I have encountered over the years (like if MS Access is running a query and the CPU is pegged, then leave me alone ), but what if it isn't Access?  How do you work with your network team to find the problem?

I am a firm believer that network n0mes don't exist.




Post #292214
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse