Sql server upgrade advice - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Sql server upgrade advice

Author

Topic

taras
Starting Member

4 Posts

Posted - 2007-08-23 : 05:57:59

Hi

We currently have a Server:
Dual Intel Xeon 3.0 GHz
4 GB ram
(C) 2x18 GB SCSI disks RAID 1 for OS
(D) 4x72 GB SCSI disks RAID 5 for Data

The server is running:
Windows 2003 + IIS (Single web application)
Tomcat (Single web application) (Is about to be outfased)
MS SQL 2005 (In simple recovery mode)

The C-driver is currently only used for OS and applications
The D-driver is holding all data + SQL Data files and SQL Transaction files...
E.g.
- SQL Data files = 7 GB
- SQL Transaction files = 20 GB
- Image liberary = 100 GB
- Other = 15 GB

The IIS uses around 768 MB ram for cashing and execution of the web application
The Tomcat uses around 350 MB ram
The SQL is the to use a max of 2.2 GB ram (and 1024 MB pr. query)
(Leaving around 512 MB ram left)

There is only one database installed on the SQL, but it is very large (+15 mill records)
We are currently doing Free-Text searches in one table (~3.5 mill records), and it is to slow.

So the question is what is the best way to gain performance...
- Increase to 8 GB ram?
- Purchase a new server as webserver, so the curr. server can be dedicated as SQL?
- Attach a NAS to split the SQL files into several groups, and seperate transaction logs from data?
(6 disks are max in curr. server)

Economy has to be considered :)

Thanx!

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2007-08-23 : 06:06:04

Best way is Purchase a new server as webserver, so the curr. server can be dedicated as SQL....

RKNAIR

taras
Starting Member

4 Posts

Posted - 2007-08-23 : 07:19:08

But currently it seems as if the server has both ram and processing power enough, as they are rarely maxed.

NB. The SQL is an Enterprise version

Whould others agree with RKNAIR?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-23 : 22:51:27

I'll work on disk arrays first.

taras
Starting Member

4 Posts

Posted - 2007-08-24 : 07:41:06

Hi rmiao

Thank you for your reply!

But what would you do... Attach a NAS ?
Take use of the Hosting Providers SAN ?

Also I would like to hear recommendations for best possible file groups/file seperation.

Thanx!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-24 : 23:28:52

Create multiple arrays on SAN, separate data files, log file and tempdb on their own array.

taras
Starting Member

4 Posts

Posted - 2007-08-27 : 03:24:13

I currently have c: (RAID 1) and d: (RAID 5)

So the following disk setup you adviced is:
C: System databases
D: Data files
E: Transaction logs (hosting providers SAN)
F: TempDB (Hosting providers SAN)
...or please correct me?

The hosting providers current setup gives me a 100 MB network to the local switch, which is connected with a 1 GB link to their backbone
You do not think that the network link would be to slow?
(Could perhaps establish a 1 GB link to the SAN)

Thanx!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-27 : 21:38:03

Arrays sound ok.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources