Rules to choose hardware for OLTP systems (sql server)

Posted by Roman Pokrovskij on Server Fault See other posts from Server Fault or by Roman Pokrovskij
Published on 2010-11-20T18:55:23Z Indexed on 2011/02/22 23:27 UTC
Read the original article Hit count: 301

Filed under:

sql-server

|

Hardware

Ok. We know database size, number of concurrent users, number of transactions per minute; should choose number of processors, RAID, RAM, mirroring and clustering.

There are no exact rule.. but may be there are no rules at all?

In my practice in every case I have "legacy" system, and after some inspections and interview I can form an opinion how hardware and design can be improved.

But every time when I meet "absolutely" new system (I guess there are no new systems, but sometimes are such tasks) I can't say anything trustful. So I'm interesting how people deal with such tasks? They map task on theirs experience or have some base formulas?

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: 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 What… >>> More

Related posts about Hardware

Older SAS1 hardware Vs. newer SAS2 hardware

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I got a question today from someone asking about the older SAS1 hardware from over a year ago that we had on the older 7x10 series. They didn't leave an email so I couldn't respond directly, but I said this blog would be blunt, frank, and open so I have no problem addressing it publicly. A quick… >>> More
Installer Reboots at "Detecting hardware" (disks and other hardware) on all recent Server Installs

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have a very frustrating problem with my PC. I cannot install any recent version of Ubuntu Server (or even Desktop) since 9.04 even using the text-based installer. I boot from a USB stick created by Unetbootin (I also tried other methods such as startup disk creator with no difference). On the Server… >>> More
Difference between "machine hardware" and "hardware platform"

as seen on Stack Overflow - Search for 'Stack Overflow'
My Linux machine reports "uname -a" outputs as below:- [root@tom i386]# uname -a Linux tom 2.6.9-89.ELsmp #1 SMP Mon Apr 20 10:34:33 EDT 2009 i686 i686 i386 GNU/Linux [root@tom i386]# As per man page of uname, the entries "i686 i686 i386" denotes:- machine hardware name (i686) processor type (i686) hardware… >>> More
Remove hardware from "safely remove hardware" list on Windows 7

as seen on Super User - Search for 'Super User'
Hi, I have a USB wifi card (D-Link DWA-125) on a Windows 7 x64 computer. The problem is that the card appears on the "safely remove hardware" list, but I don't ever want to unplug it, so I would like to remove it from the list. So far I have only found solutions that mess with the registry (and… >>> More
Windows 7 Not Recognizing Any Hardware, Linux Recognizing Hardware

as seen on Super User - Search for 'Super User'
I have a new desktop computer with two SSDs: one running Linux Mint 15 (SSD1), the other running Windows 7 (SSD2). My mint runs perfectly - USB wireless adapter is recognized, SSD2 (connected by SATA) is recognized and accessible through the filesystem, Ethernet works, etc. However, my Windows 7… >>> More