Sql 7 Server Hardware Sizing
Mar 23, 2002Can someone please point me in the right direction for calculating SQL server 7 hardware. Thank you in advance for your assistance.
View 1 Replies
ADVERTISEMENT
Sizing For SQL Server 7.0
Mar 31, 1999We 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.
SQL Server Sizing
Mar 8, 2007HI 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
Sizing Server
Mar 13, 2007Hello
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
Sql 7 Server Hardware Sizing
Mar 5, 2002Can 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 RelatedSizing An OLAP Server
Apr 16, 2008Hi 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
Sql Server Sizing Planning - Architecture Help
Jul 20, 2005HiI 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 RelatedBest Practises For Server Sizing For MS Reporting Services
Jul 23, 2005We 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 RelatedSQL Server 2005 - Database Sizing Estimations
Jun 18, 2007Hi 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
SQL Server Sizing - Hardware Requirements For SQL Server 2005
Oct 24, 2006Hi allI am having a SQL Server database of arround 110GB and 250 Users. Whatis best suited hardware requirements for handling of such a database. Iam having following requirements from the server:1. Feeding purpose : On which continously feeding is done by average200 users.2. Reporting purpose : on which average hundred of repords are runningat a time.Right now i am having two servers for both of the above said purposeswith the following configuration.Feeding ServerHPSERVER 370G43.2 Xeon Single processor3GB RAM1 SCSI 73GB 15000 RPM(OS & Transaction Log), 4 SCSI * 73GB with RAID 0(Data Files) and 2 IDE * 300GB (Backups)Reporting ServerBoard SE7520BD2V2 x XEON 3.2 GHz CPU 800 FSB with 2MB Cache4GB RAM3 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 toknow what upgrades or changes I need to do in the configurationaccording to the load and performence on existing servers. Here is thetable of performence counters along with their values to show the loadand performence for both of the servers.ReportServer ValueFeedingServer ValueCounter Instance Avg. Min. Max. Avg.Min. Max.Pages/sec 0.081 0 8.001 0.020 1.993Avg. Disc Queue length _Total 18.658 13.592 51.89634.421 0 175.783% Processor Time _Total 36.841 5.469 64.45379.837 54.688 100Buffer Cache hit ratio 97.702 93.595 99.46397.41 77.261 99.989Checkpoint pages/sec 0 0 00 0 0Lazy writes/sec 1.243 0 30.003 14.2630 97.194Page life expectancy 17 4 8110 6 14Avg. DiskBytes/transfer _Total 37934.133 7903.004128427.747 53806.538 8025.801 141750.562Avg. DiskBytes/Read _Total 16737.419 8192 42895.86254228.822 8170.499 143489.965Avg. Disk Bytes/Write _Total 12298.494 0 6553611708.014 0 92842.667% Disk Time _Total 77.555 49.976 261.966 760.35612.534 4890.383Users Connections 17 17 18195 185 212Batch Requests/sec 0.859 0 2373.215 0 205.009Transactions/sec _Total 1.768 0 18.00159.314 3 241.814Page splits/sec 0 0 0 1.030 5.007Please suggest what should be the configuration for my new server.Should I consider buying an Dual Itanium Processor based system with 16Gigs of Ram and 8 Hard Disks in Raid 0. Or Should I consider buying aQuad Xeon Dual Core Processor based system. Or may be my existing HPserver can be upgraded to dual processor and 8 Gigs of Ram and 2-3 morehard disks? Pls recommend what should be the factors that sould beconsidered, guiding priciples and my approact to reach a decision.With Best RegardsParveen Beniwal
View 2 Replies View RelatedSQL Server Admin 2014 :: Rule Of Thumb For Sizing Log Space During Index Maintenance?
Sep 13, 2014I'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.
Database Sizing
Oct 2, 2001Hi,
can anyone answer me this? I recently inherited a SQL Server database set up. The user database size is about 3 times as big as necessary - does this matter? Does it have an impact on performance and if so is there anything I can do to reduce the size? From what I have managed to gather so far you cannot use alter db to change the database to a smaller size than it was originally created at. If anyone can help it would be most appreciated!
Cheers,
Petra
Sizing Db Objects
Dec 28, 2004Hello, I'm looking for a sizing Excel (or any other format) file, that permits me evaluate the size of my sql server database, actually I have one excel file for Oracle, where I only put the expected # of rows, the average size of the columns, and other few data, and I can get the size (in Megabytes) of a table or an Index.
Could you provide me something similar??
Thanks !
Re-sizing Output Columns
Apr 2, 2002I've got a question that I can't seem to find an answer for, I was hoping someone here might be able to point me in the right direction. I've set up a stored procedure that will email someone if any entries are added to a table . However, the output is garbled looking (see below)
Client Number SSN Client Name Old SD
New SD
------------- ----------- ---------------------------------------- --------
--------
800901 899-34-3482 John Smith 04/20/20
05/01/20
400909 144-23-0029 John Smith 04/09/20
04/11/20
447788 445-89-9967 kjl;j;j 04/05/20
04/12/20
300099 234-90-7815 John Johnson 04/08/20
04/15/20
What's happened is the client name field is too wide, so the New SD field kicks down to the next line. I'd like to clean this up. Is there a way I can either increase the length of the row before it moves to the next line, or can I re-size the client name field to match the size of the data. In other words, cli_name_vc is declared as a varchar(40). If the longest name that comes up in the query is 18 characters long, can I re-size the output so that it does not take up 40 characters?
Any help is greatly appreciated.
thanks,
-scott
Change List Sizing
Nov 30, 2007I have defined a list with one row of data and three more optional rows of data
Row 1 is always shown - rows 2, 3, and 4 are shown if there is data available in those fields
By using the visiblity property I can have rows 2, 3, and 4 disapper when no data is available and appear when data is available
What I would like to do now is change the height of the list item based on if rows 2, 3, or 4 are visible (have data)
So if no data is available then the list item would only be one row high
If only one of rows 2, 3, or 4 contain data then the list item would be two rows high
so forth and so on
I noticed that the textbox can increase and decrease height to accomodate content. Looking for something similar in a list item.
Thanks!
Guidelines For Sizing Log Files In SQL 2005
Apr 16, 2008I am looking for guidelines for log file sizing, specifically where database reorgs are required
View 1 Replies View RelatedIntegration Services :: SSIS CPU And RAM Sizing
Oct 20, 2015if there is any way to accurately size a single server using SSIS. The server will be a virtual machine. The data being loaded will be approximately 200 MB per load with loading to a 150 GB database on a separate server.
View 3 Replies View RelatedSizing A Reporting Services Installation
Jan 26, 2007I am converting an old Crystal Reports environment to 2005 Reporting Services. I've seen the basic memory requirements for the SSRS programs themselves, but I was wondering if there are any other guides available that will help me size the H/W based on anticipated users and reports.
Thanks!
SQL 2012 :: Sizing Bar Of Horizontal Range Bar Chart In SSRS?
Sep 8, 2014I need to manage the height of an horizontal range bar chart inside a SSRS 2012 report.
In my report, I've a filter to read a particular data set. So, I could select five data rows or ten data rows or twenty data rows and so on. I'd like to maintain fixed the height of the horizontal bars while the number of data rows changes.
SQL 2012 :: TempDB - Tlog Sizing / Capacity Planning?
Nov 18, 2014I 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.
SQL Reporting Services 2005: Sizing Report For Printing
Feb 1, 2008I 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 RelatedSizing A Pagefile On Servers With Large Amounts Of Memory
Sep 19, 2007I know the standard Microsoft recommendation is to make the pagefile at least 1.5 to 3 times larger then the amount of physical memory. However, if you're talking about a server with lots of memory such as 16GB or 32GB, would following this rule be unnecessary. With SQL 2000 running on Windows 2000 Server or Windows Server 2003 I typically see pagefile usage no more then 12% for a 2GB pagefile. Anything over 15% means I need to look at other indicators to see if a memory bottleneck has developed. If I have 32GB of physical memory and make the pagefile only 1.5 x 32GB I have a 48GB pagefile. 10% of this is 4.8GB, which I would hope I never see consumed.
Any thoughts?
Thanks, Dave
Memory Sizing For A SQL 2000 Cluster - Windows 2003 Enterprise SP1
Oct 4, 2007
I am looking for some recommendations for memory sizing and options for a SQL 2000 Cluster. This is a two node cluster built on Windows 2003 ENT SP1 (x86). Both the nodes have the following hardware:
- 4 x Dual Core AMD Processors
- 16 GB Memory
- EMC Shared Disk
We are running six SQL 2000 instances and don't expect each of these instances to use more than 1.7 GB of memory. All these instances are going to support BizTalk 2004 Databases. I already have /PAE enabled on the nodes. I am looking for the following answers:
- Do I need to enable AWE on all the instances even if the instances ? Currently, we don't have that enabled and we have seen some issues regarding excessive paging even when there is physical memory available. The DBAs think that we don't need to enable AWE. I am bit confused on this one.
- We normally run 3 instances on each node and would like size the cluster in such a way that it can take six instances in case of a node failure
Any input will be highly appreciated.
Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
Apr 20, 2007My 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?
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql
Aug 10, 2007
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql?
Aug 10, 2007Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied
Jun 6, 2007Hi,
When I am trying to access SQL Server 2000 database from another machine i got this error
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
but I could access the database on same server and in that server i could access other databases in different server.
SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call
Sep 5, 2005Hi All,
View 14 Replies View RelatedA Call To SQL Server Reconciler Failed. SQL Server 2005, SQL Server Mobile Merge Replication
Oct 2, 2005Hi,
View 36 Replies View RelatedSQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
Feb 13, 2008When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.
Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected
problems when running both 2000 and 2005 SQL Server at the same database server?
3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade?
TIA,
Jeffrey
Query Analyzer Error Unable To Connect Server Local Msg17, Level 16,state 1/ODBC SQL Server Driver [DBNETLIB]SQL Server Does Not
Oct 20, 2007I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Apr 3, 2008Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
SQL Server 2008 :: Restoring A Database / Server Using A Remote Server As The Service Call?
Jan 4, 2013if you can restore a database to Server B using Server A as the service. Meaning we would issue the command on Server A but somehow point to Server B as where we want the restore to happen.
The backup file would be in a location independent of both servers.