SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to improve the performance of New Server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

venkath
Posting Yak Master

India
202 Posts
Posted - 06/05/2006 :  07:20:14  Show Profile  Reply with Quote
Hi guys,

I am new to SQL Server administration, Today, we have installed a new sever with the follwing configuraion.

RAM-6GB
HD-600GB
CUP Speed-6GZ.

in this server , we have a database of size 50GB
Could u tell me various server propertis i can set to improve the
performance of the database.

Thanks in advance.

Kristen
Test

United Kingdom
22191 Posts
Posted - 06/05/2006 :  12:10:24  Show Profile  Reply with Quote
Hardware check first:

Split the disks into 3 or 4 separate channels:

0 = O/S
1 = Data
2 = Logs
3 = Backup files

Use RAID1+0 instead of RAID5 for data and logs

You should have 2CPUs minimum, 4 CPUs or more if the DB is CPU intensive.

For SQL Server (2000) to use more than 2GB RAM you need Enterprise Version of both SQL and the O/S, and some special settings for the hardware.

Application / DBA check:

If you have done all of that already then its down to optimisation of the queries, good housekeeping for defragmentation of indexes, updating of statistics and recompilation of SProcs etc. that slow down over time.

You should also be creating a disaster recovery plan.

As you mention "I am new to SQL Server administration" I expect that lot is a pretty big stretch (if it was my server I'd be looking for someone with 3-5 years experience, assuming a high-demand system).

But feel free to ask any specific questions for problems you come up against.

Kristen
Go to Top of Page

wkl2
Starting Member

5 Posts
Posted - 06/05/2006 :  13:57:26  Show Profile  Reply with Quote
*** "You should have 2CPUs minimum"

is having a dual core CPU equivalent?

thanks, wkl
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 06/05/2006 :  14:16:27  Show Profile  Reply with Quote
"is having a dual core CPU equivalent"

Yes - TTBOMK

Kristen
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3241 Posts
Posted - 06/05/2006 :  16:51:04  Show Profile  Reply with Quote
Have your developers use WITH (NOLOCK) is my contribution. All selects cause locking of data and at least in my company 98% of queries are on historic or non-critical data. The performance-increase on an intense system can be dramatic. Syntax:
SELECT *
FROM table 1 a WITH (NOLOCK)
  INNER JOIN table2 b WITH (NOLOCK)
    ON a.ID = b.ID
I'm aware that this is not exactly what you asked for but since I'm not a hardware-person this is what you get

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000