Database Capacity Planning

Sep 27, 2001

Does any one know where I can locate a document or template for database capacity planning on the web? Any help would be greatly appreciated. thanks.

View 1 Replies


ADVERTISEMENT

Capacity Planning

Nov 4, 2000

hi, can any one tell me what is the meaning of capacity planning and where do I get info about it,and how does this help me in sql server admin role
thanks

Ahmed

View 1 Replies View Related

Capacity Planning

Dec 11, 2000

What si capacity planning?
Where can i find more stuff on it?

View 1 Replies View Related

Capacity Planning !!!

May 28, 2001

Hi Everybody,

Can anybody explain me, what is Capacity Planning and what is Load Balancing?

tks in advance
sri

View 1 Replies View Related

SQL Server Capacity Planning Best Practice

Aug 8, 2007

Hello,

I have been working on SQL Server Capacity Planning for a few weeks now and have gathered a lot of materials, but non of thes materials contain recommended best practices on SQL Server capacity planning and also they do not contain operational guidelines.

I would be glad if anyone can recommend a website or book that contain information on SQL Server Capacity Planning Best Practices.

Thanks,
Jide

View 3 Replies View Related

SQL 2012 :: TempDB - Tlog Sizing / Capacity Planning?

Nov 18, 2014

I am in the process of formulating recommendations with respect to the purchase of additional storage for our current SQL 2012 SharePoint (2013) instance. My recommendation is to purchase separate storage (i.e, 15k disks) for the TempDB and Tlogs respectively (two sets of raid 10 disks). Currently, this server is hosting several instances, including SP, using two arrays (one for database and the other for Tlogs).

I am attempting to find information/recommendations on how to go about projecting the amount of storage for each of these while factoring in for growth.

Additional Details:

how to best formulate a reasonable estimate. Our largest content database belongs to IT and is currently ~80GB. That said, this is currently an outlier. The remaining content databases are less than 10GB (most are less than 2-3 GB). However, SharePoint will be used for digital document imaging in addition to, eventually, replacing file shares as our primary document storage medium once we roll it out.

Our current tempDB is ~400MB, but the instance was recently started a few days ago, as we had to failover to our backup server for hardware maintenance. I do not have any historical data on TempDB growth at this time. Also, I don't know how useful this would be given we have not fully deployed yet.

View 0 Replies View Related

Planning A Database

Aug 7, 2007

Hi all,

I'm very new to SQL and am learning via books and whilst on the job. I'm putting together my logical design at the moment and was wondering if anyone could suggest any websites that might give me an insight into the best way to go about this in an effective manner.

TIA,

SamuelT

View 1 Replies View Related

Database Capacity

Jun 26, 2007

Hi,
I€™m working in a DWH project the source system have data from passed 30 years and the total number of records from the source system is 10 million.

I€™m need to do the estimation for the data base for the up coming 10 years of data.
As I can predict that the 30 year of data is 10 million then expected data for 10 years would not be more then 3 million.

The ETL tool I€™m using is SQL Server Integration services and the reporting tool is Business Objects.

Can any one guide me on the implementation plan, mean memory taken for ETL jobs (As SSIS use large amount of memory) database and business objects.

View 2 Replies View Related

Need Advice On Planning For DataBase Changes

May 16, 2005

Hello;

View 8 Replies View Related

Planning For Creating A Database

Nov 16, 2007

Dear Experts,
now i was allotted as a complete DBA for one client and i've to take care from the creation itself.

we've understood the data will be around 20 GB initially, and from there onwards, 1GB data will grow in the database. total number of tables are around 1400. and we have primary key on each table.

Now you Experts, please guide me that how can i take the Fragmentation levels for best performance? or i need to give you more information regarding that.....

i need your valuble suggesions and guidence

View 2 Replies View Related

Planning Database On SQL Server 2005

Apr 30, 2007

Hello,
We are establishing a database server for our product suite containg 14 products- these products is basically intended to be used by CAs and Accountants.

my databaseserver will have 14 databases-
4 are very small, 4 are complex and 6 are Very complex- there is a close intraction between all these databases.
at any time there will be around 500 users using these products but since these products are seasonal there is a chance that all 500 users are connected to one database only.(but there is also a possiblity that load is equally distributed on all the databases)
My product will run on intranat.

My requirement is:
1. What is best server configuration for hosting such type of database.(sqlserver 2005)
2. How many concurrent users sqlserver supports(MSaccess supports 15 concurrent users)
3. I want that if user has license for 10 users my Database should bear load of only 10 user.

View 1 Replies View Related

Model Database Recovery Planning

Mar 29, 2007

I cannot think of any reason, in our environment, why I would recover the model database. Change framework has all databases coming from DEV & QA before landing on PROD. We have never used the model database as framework of new databases either.

So, if I discontinued backup of the database, what is my recovery method if it become corrupt? Since mine is not used, can I simply copy it from another server?

View 5 Replies View Related

Planning Database Storage For SQL Server 2005

Feb 13, 2008

Here are my planning details:

RAID 1:

2 disks RAID 1 for OS and BINS
2 disks RAID 1 for Backups.

RAID 10

4 disks RAID 10 for data
4 disks RAID 10 for log
4 disks RAID 10 for TEMPDB

Should i put the master and other system database on RAID 10 along with TempDB.

Or what else a guru fellow will advise in above setup.

thanks,

View 5 Replies View Related

SQL 2005 And SQL 2008 Database Volume Capacity

Dec 1, 2007

Hi Everybody:

4 -5 years ago, I started my career as a translator translating the MetaTexis CAT (Computer Aided Translation Software).

It's amazing to see all the improvements that have been made until now, but recently I found some problems regarding
databases:

I heard that ACCESS databases volume is limited up to 2 GB and that SQL 2005 databases volume is limited up to 4 GB, but I think this information is wrong, or at least I was only able to import 10% of that amount.

Speaking in words, 2 GB doesn't represent a database with a volume of 125,000 segments/sentences (for ACCESS) and 4 GB a volume of 250,000 (for SQL 2005).

Concrete, my "mega.mxtm" database has "only" 359 MB and suddenly I refuses to import more sentences. Is that normal? (MICROSOFT SQL 2005)

Question: Is the new SQL 2008 also limited? Is there any way to "free" or increase the volume capacity?

Point 2: As I updated the SQL 2005 into 2008 I am not able to open the "old" "mega.mxtm" anymore... : (

Regards!


De Sena Viegas

View 4 Replies View Related

DR Planning Help....

Mar 8, 2007

I was told that my company is thinking about inplementing a "backup" server for out content loading server (aka load server)... this server loads files from several companies and then replicates the data out to our production environment to be seen. This server has serveral DTS/IS packages that do all this data movement and manipulation... I am not too up to date on technology for what they are asking so I thought I would ask here for some recommendations to head in the right direction...

I am not sure if clustering will work or maybe mirroring the database...

The server now is a publisher so the backup server would have to pick up if the #1 failed and then give command back to #1 once it is good... this is the part I have no idea about...

The #2 server would not have to really do anything but keep its data up to date unless #1 fails so you could say it would be fine to be a passive server...

Any ideas on what direction I should look into???

Thanks ahead of time.

View 8 Replies View Related

Sql Server Capacity

May 13, 2005

Hi,
any1 know how many records can be stored in a table in sql server? is there any way to maximise it? will table capacity (number of records) vary due to our table stucture or database structure? is there any documentation bout tis?
Cheerslife's Ng

View 2 Replies View Related

Planning To Install SP3

Jan 8, 2001

Hi All

I am planning to install SP3, anyone have suggestion before installation what are the precaution I need to take. please post your comments. Thanks in advance.

Thanks

Regards
Leong

View 1 Replies View Related

Replication Planning

Feb 8, 2001

Hi every body,

my company wants implements transactional replication. We have three servers one in chicago(production)
second server in chicago, third server in kansas city.Can give me plan for implementing the replication.

Thanks

View 1 Replies View Related

Maximum Capacity Of A ROW!

Nov 29, 2000

Hi Everybody,

Our development team is doing some stuff in ASP. They are interested only in char and varchar
data types. They clearly told us that they are not going with text and image data types.

Is it possible to make a row size behind 8060 bytes in a table without text and image data types?.

tks in advance,
Sri.

View 1 Replies View Related

New SQLSERVER Planning?

May 26, 2004

Hi Guys,

We are planning for a new SQLSERVER for one of our application. The database will receive around 58 million events/year is roughly 160,000 messages/day

Making the assumption that an average message size is 2K. The messages comes to database through edi processes.

Any suggestion about database server configuration, and any other steps that need to be take care of before even thinking about creating a database??

help is greatly appericated..

View 3 Replies View Related

Capacity Plan

Mar 9, 2000

Hi!

I got two questions and please forward all your suggestions:

1: Is there any document for capacity planning of SQL Server 6.5 database?

2: Is there a way to find out total number of transactions per day in SQL Server?

Thanks in advance!

View 1 Replies View Related

Capacity Of SQL Server

Feb 20, 2001

I have a flat file with about 2000 fields and 2 million records. I can reorganize the data any way I want and have a unique id field for each record.

Is SQL Server a suitable solution do you think, and also how many fields will a table take (I think access takes 255)?

If you think there may be a better solution for me to look at I would be glad to hear.

Thanks for any help

View 1 Replies View Related

Capacity Planing

Feb 8, 2007

Hi All,

We need to do capacity planning for our SQL server database server. Capacity planning is interms of CPU usage, Memory usage and disk usage.

Can anybody help me with how should I start and what are the guidlines to do it? I have started executing perfmon utility with some counters but still not sure what to do next. Please help me. Thanks in advance.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

View 2 Replies View Related

Project Planning

Feb 13, 2007

HelloBased on three tables (Projects, Tasks and UserCalender) I would liketo work out the total amount of available resources (UserCalendertable contains a entry for each user for each day, day being 7.5hours) and total required effort (sum of Tasks.EstimateLikley) splitover 12 months.For example:Jan:Available Resources: (4 Users, 7.5 hours per day, 5 working days perweek, 23 Working days in Jan) = (23 x 4) = (92 * 7.5) = 690 AvailableHoursRequired Resources:Project Start Date: 1/1/2007Project End Date: 1/6/2007Total Required effort (Sum of Tasks.Hours for above project): 500Hours Average over 6 months = 83.33 Hours per month, so in Jan I needto deduct 83.33 from 600 = 516.67 Hours.etcHow could I do this, I have tried several ways but finding it hard.Thanks

View 1 Replies View Related

Planning On Going With Dynamic SQL, But...

Jun 13, 2007

I've read a few posts on the stored procedure vs dynamic sql debate. I ran a few performance test for myself and it appears to be a wash.



Given that, I'm leaning toward dynamic sql mostly because it would mean one fewer place to have things.



But, before we go that route we wanted to ask the question:



Is there any compelling reason why we shouldn't abandon all of our stored procs and just write the SQL inside inside our functions in our business layer (essentially our data access layer)?



Or, is it just preference these days?



I was leaning toward procs, but I have to admit it would be nice not to have to keep up with all of them per all of our functions that call them.



Thanks,
Ron

View 3 Replies View Related

Planning A Replication

Aug 5, 2006

hallo
we have a sql2000 in the headquarter, and 3 new remote branches opening in few weeks with no sql servers installed yet.
We plan to setup a merge replica. The headquarter will have the highest activity on the replicated tables.
Shall we use all SQL2000 in the remote branches? Or could we use SQL2005, using a 2005 as a publisher and distributor?
TIA

View 3 Replies View Related

SSIS Capacity

Sep 12, 2007

Hi ,

We need to upload over 100 GB file into SQL Server using SSIS. I want to know whether SSIS can upload such huge file in to a table. If yes, How ?. If not is there any work around to achieve this.

Expecting some solutions ASAP

Thanks
Regards
Pandithurai K
Singapore

View 3 Replies View Related

Planning Ahead W/ SQL Server...

Jan 3, 2004

With the current web app that I am writing, I am starting to plan ahead to the scalability problems that I am planning on encountering with the number of users that I may have...

My hosting plan now allows for a 50MB SQL Server database, but, I know that will not last long, each user will be using 3-5MB each of the database, so I am going to outgrow my space fast.

Would looking into (until i have enough subscribers to get a dedicated host), SQL Hosting be a good idea? Atleast to start off with something like http://www.alentus.com/hosting/sqlserver.asp ?

But then again, would a SQL Database growing to large get bad? Within a few years, i expect to have at max 5,000 users, so that could grow to a 25GB database... with millions of rows.

Would breaking it up into smaller databases for each N amount of users be a wise idea? Or would it not really matter?

Any help is much appreciated

Happy New Year
Harold.

View 1 Replies View Related

I Would Like To Find Drive Capacity Using SQL... Is This Possible???

Jul 10, 2001

Hey - I know that xp_fixeddrives gives me the amount of free space on a drive. Is there a similar (xp) function that will give me the capacity of a drive??? Any help is appreciated. Even if you can just point me in the right direction. Thanx in advance. Billy

View 1 Replies View Related

License Information And Db Capacity

Mar 27, 2007

hello,

I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:

1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.


2. Does the developer need to purchase a seperate license for distributing the .sql file?

3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.


NOTE: No Sql Server Software will be installed on client machines.

In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?

Please, somebody can help me for the licensing information and also for the database size?

Thank you.

View 1 Replies View Related

Planning Multiple Queries

Dec 2, 2005

I'm cleaning data which involves updating ~12 million rows with threedifferent models, progressively. First clean values using the modelwith finest granularity, then the remainder with the next model,finally what's left using the last model. The first model sets ~1/2 ofthe rows, the second ~1/4, the third ~1/5, and the remaining 5% don'tget updated.It's something like this:UPDATE t SET value=value*m.AdjustmentFactor, updateFlag='updated'FROM Table t JOIN Models m ON ....WHERE m.ModelID='first model' AND t.updateFlag IS NULLStart with 'first model' then 'second model' etc.I'm wondering what happens if I submit all three queries together, oras three separate submissions, waiting for the one before to complete.If I do them all as one group, the query planner might plan for thesecond and third updates based on the initial distribution of values.However, the first update removes half of the rows from consideration,so it seems to me a new plan should be prepared for the second query,based on the distribution at that time. If I highlight the queries inQuery Analyzer and execute, are all three plans created at thebeginning? Does putting GO between them (which I do) make anydifference?This is SQL Server 2000.Thanks,Jim

View 2 Replies View Related

SSRS Hardware Planning

Oct 18, 2007

I've done a fair amount of hardware planning for the SQL Server Database Engine. Now I'm doing so for SSRS which I don't have as much experience with. I haven't been able to find much information, especially around RAM capacity and have a few questions. Any responses or pointers to resources are appreciated.

Scenario: 2 load-balanced SSRS 2005 App servers with an independent back-end SQL DB for the config database. Total userbase is about 2000 (not simultaneous), and I'm still trying to get statistics for per hour requests. May also install multiple SSRS instances on these boxes with one of them in Sharepoint Integrated mode (don't anticipate high volume here). Load-balancing is for both performance and availability goals.

I'm looking at the SSRS App servers only and am analyzing amount of RAM, 32 vs 64 bit, and perhaps CPU core count.

1. Does 32-bit Enterprise SSRS benefit from more than 4 GB on a server, using AWE or other memory extension? Or is anything > 4 GB unused at 32 bit?
2. Are there material benefits to going to 64-bit OS / SSRS and increasing memory above 4 GB? (does IIS handle this?), Perhaps to 8 or 16 GB.
3. The boxes will be 2-way, dual core, with possibility of going to quad core. Is increasing core count a better use of budget than increasing RAM above 4 GB?


I've read the white paper, "Planning for Scalability and Performance with Reporting Services" (http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx) which briefly (but incompletely) discusses 32 vs 64 bit, and really doesn't touch on RAM at all.


Thanks for any pointers,

Scott

View 2 Replies View Related

Licensing Information And Db Capacity

Mar 27, 2007

hello,

I dnt know if this is the right place. I'm sorry for that.

WEll, I just completed my graduation and eventually i got a proposal from a company to develop a software for database management. I have some doubts about licensing the back-end database. My doubts are:

1. If I'm using Sql Server as the backend and the .sql file placed on the server where this .sql file will be accessed by about 20 clients, will the customer (company) have to purchase a license for the sql server? If yes, how this can be done? Does the company have to purchase a license for each client and server for accessing contents of the .sql file? Actually, there will be only 1 server and abt 20 clients.


2. Does the developer need to purchase a seperate license for distributing the .sql file?

3. Also, wat is the maximum capacity of an sql database size? I'm asking this because as per my requirements, the company will be using the database at a rate of 1GB per month. So, by end of a year, it will be 12 GB.


NOTE: No Sql Server Software will be installed on client machines.

In brief, my doubt is: Do we need license for reading and writting to .mdb or .sql file contents and do we need seperate license for distributing them?

Please, somebody can help me for the licensing information and also for the database size? the database will be also used for remote access.

Thank you.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved