SQL Server Sizing - Hardware Requirements For SQL Server 2005
Oct 24, 2006
Hi all
I am having a SQL Server database of arround 110GB and 250 Users. What
is best suited hardware requirements for handling of such a database. I
am having following requirements from the server:
1. Feeding purpose : On which continously feeding is done by average
200 users.
2. Reporting purpose : on which average hundred of repords are running
at a time.
Right now i am having two servers for both of the above said purposes
with the following configuration.
Feeding Server
HPSERVER 370G4
3.2 Xeon Single processor
3GB RAM
1 SCSI 73GB 15000 RPM(OS & Transaction Log), 4 SCSI * 73GB with RAID 0
(Data Files) and 2 IDE * 300GB (Backups)
Reporting Server
Board SE7520BD2V
2 x XEON 3.2 GHz CPU 800 FSB with 2MB Cache
4GB RAM
3 SCSI * 73GB with RAID 0 (Data Files and Transaction Log), 2 SATA *
300GB (Backups) , 1 80GB IDE(OS)
I want to fullfill both of my requirements from a single . I want to
know what upgrades or changes I need to do in the configuration
according to the load and performence on existing servers. Here is the
table of performence counters along with their values to show the load
and performence for both of the servers.
ReportServer Value
FeedingServer Value
Counter Instance Avg. Min. Max. Avg.
Min. Max.
Pages/sec 0.081 0 8.001 0.02
0 1.993
Avg. Disc Queue length _Total 18.658 13.592 51.896
34.421 0 175.783
% Processor Time _Total 36.841 5.469 64.453
79.837 54.688 100
Buffer Cache hit ratio 97.702 93.595 99.463
97.41 77.261 99.989
Checkpoint pages/sec 0 0 0
0 0 0
Lazy writes/sec 1.243 0 30.003 14.263
0 97.194
Page life expectancy 17 4 81
10 6 14
Avg. Disk
Bytes/transfer _Total 37934.133 7903.004
128427.747 53806.538 8025.801 141750.562
Avg. Disk
Bytes/Read _Total 16737.419 8192 42895.862
54228.822 8170.499 143489.965
Avg. Disk Bytes/Write _Total 12298.494 0 65536
11708.014 0 92842.667
% Disk Time _Total 77.555 49.976 261.966 760.356
12.534 4890.383
Users Connections 17 17 18
195 185 212
Batch Requests/sec 0.859 0 23
73.215 0 205.009
Transactions/sec _Total 1.768 0 18.001
59.314 3 241.814
Page splits/sec 0 0 0 1.03
0 5.007
Please suggest what should be the configuration for my new server.
Should I consider buying an Dual Itanium Processor based system with 16
Gigs of Ram and 8 Hard Disks in Raid 0. Or Should I consider buying a
Quad Xeon Dual Core Processor based system. Or may be my existing HP
server can be upgraded to dual processor and 8 Gigs of Ram and 2-3 more
hard disks? Pls recommend what should be the factors that sould be
considered, guiding priciples and my approact to reach a decision.
With Best Regards
Parveen Beniwal
View 2 Replies
ADVERTISEMENT
Jun 18, 2007
Hi there,
I've been searching the net the entire day for accurate information regarding SQL Server
database sizing estimations. I currently need to find an accurate link that will display all of
the data types supported by SQL Server 2005, the characteristics of each data type (Max
and Min Values, etc), and the physical storage size (KB and / or MB) of each data type.
The reason why I want this information is because I want to work out the current size
of each table in a Database as well as all Index sizes, and with the calculated information
predict what size the database will be in a few months and / or years.
It has been quite a mission to find the information, and when you do it isn't very clear at
all.
Any help would be greatly appreciated.
Have a good one,
Colin
View 4 Replies
View Related
Jun 21, 2007
Is there any good online documentation describing rules of thumb for estimating and planning a SQL Server 2005 deployment in support of a Windows rich client/WCF services architecture?
TIA,
Ian
View 3 Replies
View Related
Oct 20, 2006
I am trying to do an upgrade in place from SQL Server 2000 SP3a to SQL Server 2005. I am encountering the following error. SQL Server Setup has encountered the following problem:[Microsoft][SQL Native Client][SQL Server] Password validation failed. The password does not meet Windows policy requirements because it is too short...To continue, correct the problem and then SQL Server setup again. I read the other posting and it mentioned that the sa account needs to be changed. I have changed the sa account to meet the passowrd requirements for our system and have changed the following services I could find over to my domain account which I know meets the password restrictions. If I do a new install, everything seems to load correctly. What options do I have to do this upgrade in place?
Thanks for your help,
Bill
View 5 Replies
View Related
Jul 13, 2006
I do get the warning about Minimum Hardware Requirement, but can
find nothing in the detail requirements to exclude my PCs configuration.
I have installed:
IE 6.0 sp1
IIS as a part of Win 2000 Professional Edition SP4
I have also used ..aspnet_regiis -r to register ASP.NET 2.0
.NET Framework 2.0
SQL Server Native Client
SQL Server Setup support files
PC includes:
Pentium III 800 MHz
512 MB memory
HardDrive C: 5.92 GB (1.37 GB free)
HardDrive D: 13.1 GB (9.11 GB free)
I have tried several times to install SQL Server 2005 Developer Edition
(most recently from MSDN Disk 3097.1) I have tried to
complete an uninstall before each attempt.
I am, successfully, running Visual Studio 2005.
Any suggestions will be appreciated.
View 5 Replies
View Related
Feb 10, 2006
This doesn't make any sense. I am trying to install SQL Server 2005 on SBS 2003 with Service Pack 1. According to Windows Update, there is nothing left for me to install. However, I am getting this error (while installing SQL Server Express and the Developer Edition):
"Your operating system does not meet Service Pack level requirements for this SQL Server release. Install the Service Pack from the Microsoft Download Center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server setup again."
When I go to the link, there is nothing there to download (it takes me to the main Microsoft download page). I meet all the requirements that I have found. What gives?
Thanks,
Scott
View 36 Replies
View Related
Mar 31, 1999
We are considering migrating our Oracle database over to SQLserver 7.0. I'd like to do some sizing estimates, but I have not been able find any methods for sizing SQL server 7.0 databases. There didn't seem to be any calculation guidlines or formulas in the manual or the online documentation. The only formulas I have found on the WEB are for version 6.5. Does anyone have (or know where I can find)formulas that are valid for sizing SQL server 7.0 databases?
Note: an archived message on this site referred to an attachment containing sizing formulas, but the attachment was not accesible.
View 2 Replies
View Related
Mar 8, 2007
HI everybody,
We are designing a system using .NET/ASP.NET and SQL Server (2000 Standard as a customer requirement). The system will be hosted into 2 dedicated servers (an web/application and a db server) and we need to estimate the hardware requirements needed.
Could anyone help me on sizing this? Is there any literature on how to do this? I found some sizing web sites but I'd like to double check them. I already have some estimation on data storage size/growth based on some information I've got from the customer.
Thanks in advance!
Sergio
View 1 Replies
View Related
Mar 13, 2007
Hello
I am sizing a database server for Business Objects Enterprise XI R2. In addition to housing this database we plan on consolodating a few other databases to this server. I am wondering what type of array I should be considering for these databases.
I will be installing on HP DL380
Thanks
View 1 Replies
View Related
Mar 5, 2002
Can someone please point me in the right direction for calculating SQL server 7 hardware. Thank you in advance for your assistance.
View 2 Replies
View Related
Mar 23, 2002
Can someone please point me in the right direction for calculating SQL server 7 hardware. Thank you in advance for your assistance.
View 1 Replies
View Related
Apr 16, 2008
Hi there,
We are experiencing some contention of resources between our RDBMS and our OLAP environment; both SQL2005; so we are going to put the OLAP side of life onto another seperate box. Therefore I need to work out what sort of requirements we are going to need; and this is where i have no idea.
I have had a look at the HP sizers, however this is looking primarily at normal RDBMS setups rather than specifically for OLAP. Is there any specifics that I need to consider/nail down before working this out?
To give you an idea:
We currently have 210 million rows in our main fact table, and each row is averaging about 330 bytes
The size of our current OLAP database is only 4GB
It appears as though we are currently getting anywhere between 6 and 20-30 concurrent users
Considering the above; I would have thought a dual core cpu setup (maybe x2) with 8-10GB of ram would have been the ticket?
Now I have done a server sizing exercise for a normal SQL2005 installation; considering temp db on seperate spindles to the log and database tables etc; but what sort of considerations do I need to do for a server running SSAS?
Thanks in advance for any assistance anyone can offer on this front
Regards
Troy
View 3 Replies
View Related
Jul 20, 2005
HiI joined a project where 100,000 rows were added everyday. Now due toadditional customers the expectation is 2 million reocrds/day ie 10 GB worthof textfiles. We have to estimate the hard disk, memory, # of CPUs etc.Wewill have one yearworth of data in the db. Rest will be in tapes etc.We will be using WIN2000, SQL Server2000.- Any comparable server sizing willbe appreciated.1. Tohandle every day load, I thought that we will have a table for each day(pre created in the database )and have a view with union all selectingfromall these 365 tables. (This is the only way to partition in MSSQL Serverright?).2. The requirement is to populate datawarehouse tables with all the data.However there will be only inserts mostly but there can be updates too whichhappenned in the past 12 days.Hence we have to use the data from the last12 days and massage it etc and populate into datawarehouse tables.How can I do this so that I will have the datawarehouse tables with n-12days of data and I will alwys add the last 12 days data to it.Do you have any suggestions?Ragu
View 3 Replies
View Related
Jul 23, 2005
We are planning to deploy the MS Reporting Services. Unfortunately,there isn't much guidance on how to effectively size a server.Here are my questions:1) In an environment with 1 reporting server (hosting the reportingdata layer, application, and management layer) connecting to 1 or moreSQL servers (over 2 trunked 1Gbps switches connections), what is theconstraining resource when running large reports against a database ofsay 4GB in size? CPU, RAM, DISK, or Network speed on the ReportingServer? Or the Data hosting SQL server? Or does it depend on code?2) If I have a Duel Core CPU, do I buy 1 CPU license. MS had respondedto the HyperThreading as 2 virtual CPUs with the statement that you buyCPU licenses based on socket count effectively. This would imply thatif I buy a 4 Duel Core AMD Opteron Proliant 585 (8 CPU cores in 4packages / sockets), I can run MS Reporting Services Standard Edition.Is that true?Any input or direction would be appreciated.Paul V.
View 1 Replies
View Related
Sep 13, 2014
I've been fixing some issues lately where weekly maintenance has been causing logs to grow and filling disks.
Is there any rule of thumb for allocating log space for doing reorgs and rebuilds in a worst case scenario? I'm thinking 3x the largest database size?
I've been watching them run on databases in the range of 50GB where the logs are growing well over that for rebuilds or even reorgs. Once you have a few databases like this on a server, you can suddenly eat through a lot of disk space just for holding logs during maintenance.
View 3 Replies
View Related
Feb 13, 2007
I recently was moved into an applications developers position here at the lawfirm I work at.
Thusfar, its been alot of straight ASP, SQL2000, and Access.
I know the need for me to know .Net is coming, and Ive decided to start playing with ASP.net so I can look a bit proactive..
Ive looked over what I need to get started, in liu of Visual Studio I know of the VS Express options. However, I currently have SQL Server 2000 installed locally on my machine along with IIS 5.1. All the VS Express information Ive found keeps referencing SQL2005 express. Can I get away with using what I already have with 2000? Or if not, can SQL2005 express be run alongside with SQL2000?
Any assistance would be greatly appreciated.
Brian
View 2 Replies
View Related
Nov 21, 2000
Hello!
Does anyone know where can i find an information about hardware requirements for SQL-Server 2000. I mean information of different kind of cases (amount of users and transactions etc).
thanks!
Juise K.
View 1 Replies
View Related
Dec 26, 2006
We need to create a SQL server login that should not be having permissions to do any changes (CREATE/ALTER/DROP) on database objects like (Tables, views).But should be able to (CREATE/ALTER/DROP) stored procedures. Also using this login they should not be able to (CREATE/ALTER/DROP) databases.
Please let me if this is feasible in SQL Server 2005.
View 6 Replies
View Related
Apr 16, 2008
I am looking for guidelines for log file sizing, specifically where database reorgs are required
View 1 Replies
View Related
May 30, 2007
Hi!
I am installing SQL Server 2005 Express as part of my setup. On Windows 2003 Servers with password policy enabled, the SQL Server 2005 Express installation fails. Here is the error I am getting - "the sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.". If I disable the password policy, the SQL Server 2005 Express installation is OK.
Is there a parameter that I can pass to the command line to get around this?
Thanks!
View 3 Replies
View Related
Jul 20, 2006
Is it necessary to have SSIS installed on the Server (SQL Server) in order to run SSIS programs? Or is SSIS just a client-side, developer tool that can create and test programs against various remote data sources (SQL, Oracle, flat files, etc.)?
What must be installed on the server in order to run SSIS programs?
View 1 Replies
View Related
Feb 1, 2008
I have a report that is a little wide, and when I export it to an Excel file it spans about 2 pages. I have it set to an 8.5 height and 11 width for printing in landscape on normal-sized paper. But is there a way to make sure that the report exports with the printing page break covering the entire width so that the report prints only one page across? The users don't want to resize in Excel before printing.
View 3 Replies
View Related
Feb 25, 2015
CREATE TABLE #tblTemplateBlocks
(
TemplateID int,
BlockID int,
OrderID int
[Code] ....
I have a table called TemplateBlocks which contains which Blocks are on a Template. In this example - just one template - with three Blocks.
Table tblFields contains a list of Fields that are on each TemplateID/BlockID. In this example there are 3 fields on each TemplateID/BlockID pair.
Before I can use a template, I have to check that, in tblFields, for each Template/BlockID pairing - one of the fields must be set as the Stage Base (I cannot have 2 fields as StageBase or no fields as StageBase). In the example data above, the data would be okay as each Template/BlockID pairing has one row where StageBase is true.
Having checked that each Template/BlockID pairing has a StageBase, I need to check that each row where StageBase is true has a value for the WeekStart column and that, taking into account the order of the Blocks in tblTemplateBlocks, the values in WeekStart for each TemplateID/BlockID pairing are getting progressively bigger.
So, for example, the example data above would fail because the third TemplateID/BlockID pairing has no value for the WeekStart column in the row where StageBase is true.
If I added a value of 2 for WeekStart in the row for the third TemplateID/Block that has a StageBase of true - again the data would fail because, taking into account the order of the Blocks - the values for WeekStart would be 0,3,2 and these numbers need to increase.
0,3,4 would be fine.
0,3,10 would be fine.
0,3,3 would fail.
I can do this easily using a cursor or two - but how to do this without cursors.
View 9 Replies
View Related
Dec 13, 2006
Hi,
We are migrating all dbs to SQL2005 one by one and now planning for a database mirroring. I would like to know the following:
1. My database(one main production) size on the primary is around 1TB. So having said that we are goin to have a db mirroring, do i need to have the same hardware requirements on the mirror also?? do i need 1TB space on the mirror server also? is there anyway it can use the same hardware that primary is using?
2. For the high availability configuration in mirroring, we are prefering to have a witness server too. Does the mirror server need to have same h/w configuration as the primary(64 bit, AWE, etc). Can the witness be a 32bit, 4 Gigs RAM?
Could anyone please answer the above and that will be very helpful. This is a bit urgent.
thks,
Mani
View 2 Replies
View Related
Dec 21, 2007
Hi,
I have a VB.NET program which creates a Job (Microsoft.SqlServer.Management.Smo.Agent.Job) and schedules it, to load and run a existing SSIS package, which is on a different server.
I'm using the following assemblies for this purpose.
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll
To make this application run in my application server, do i have to install any SQL server components or SSIS rumtime components? Or Is it enough if i copy only the above mentioned dlls to my applications bin directory, in my application?
Note: I have the enterprise edition of SQL Server 2005 installed on my database server.
Thanks in advance.
Karthik
View 4 Replies
View Related
Jul 31, 2015
Basically I'm trying to produce a report that shows qualified employees for each program. Each employee can possess many qualifications. There will be no programID parameter submitted by the user. I just want to produce the report which shows the programs and the qualified employees for each. I thought I had a query that was working but once I added a different ProgramID into the ProgramModules table things went south.
Here are my tables:
tblEmployees (table of employees)
- EmployeeID
- EmployeeName
tblQualifications (table of qualifications)
- Qualification_ID
- QualificationTitle
tblEmployeeQualification (table of all employees qualifications)
-EmpQualificationID
-EmployeeID (fk for tblEmployees)
-QualificationID (fk for tblQualifications)
tblPrograms (table of programs)
-ProgramID
-ProgramTitle
tblProgramModules (table of qualifications required by each program)
-ProgramModuleID
-ProgramID (fk for tblPrograms)
-QualificationID (fk for tblQualifications)
Here is the query I was working with that works when there are only records in the ProgramModules table that use the same ProgramID
SELECT
tblProgramModules.TrainingProgramID,
tblEmployees.EmployeeID,
tblEmployees.EmployeeName
FROM
tblEmployees
[Code] .....
View 6 Replies
View Related
Jun 14, 2006
Can 2005 be installed on XP Media Center Edition? I looked on the SQL site,
but it only references Windows XP, not this particular version. Any whitepapers, links, etc., would be especially appreciated.
TIA, ChrisR
View 1 Replies
View Related
Nov 6, 2007
Hi ,
I want to install a new SQL 2005 server. i looked on MSDN, it says to create one or more domain user accounts. That means to create a windows domain. Is it neccessary? All I want is a stand-alone SQL server. right now we are working with SQL 2000 and we want to build a new server with SQL 2005.
Please send me a short feedback.
View 6 Replies
View Related
Dec 4, 2007
Hi,
I was hoping to learn from real world experience regarding the hardware requirements for SQL 2005. For both the 32 and 64 bit OS the minimumn recommendaiton is single processor, 1GB or more, 512 MB RAM.
http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx
This seems very thin and I was wondering if anyone had recommendations for hardware configs for a mirrored db cluster? I'm filling in as a DBA and apologize for the ignorance.
Jody
View 3 Replies
View Related
Jun 7, 2007
Hello,
I'm wondering if it is possible to install SQL2005 standard edition on a standard dual core pc with Win XP Pro SP2 OS.
Kindly advice.
Regards
Andy
View 3 Replies
View Related
Jun 30, 2007
I tried to install an ALLDATA database which run with SQL Server 2005 express edition. The data base fails to install becase of the following code that come up which is related to AS password requirement. The error that come up is:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------
I am trying to install this database in a network server operating under Windows Server 2003 R2 with SP2. If anyone knows how to solve this problem, please let me.
Thanks,
Amilcar
View 6 Replies
View Related
Apr 20, 2007
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.
I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
View 8 Replies
View Related
Sep 3, 2007
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
Chuck
View 4 Replies
View Related