Need Better Performance. - 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 2000 Forums

SQL Server Development (2000)

Need Better Performance.

Author

Topic

babu.knb
Starting Member

2 Posts

Posted - 2007-03-19 : 08:10:00

Dear friends,

I am having 10GB for my database. In my table having 10 Millian records per day. I want to select records per date and by product status. So,

1. How can I design my Database initialization paramet ??
2. How can I tune my database for better performance.

My Machine Configuration :

Windows 2003 Server OS,1 GB Ram, 80 GB Hard Disk, 3.99 GHz

Regards

Babu B

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-19 : 09:08:50

Let's see, are you saying you want to select 10 million rows??????

First thing I would say is to upgrade the memory

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

pootle_flump

1064 Posts

Posted - 2007-03-19 : 09:36:13

FYI
http://www.dbforums.com/showthread.php?t=1616254

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources