SQL Server 2000 Performance

[scotward]

I am building a prototype database in SQL Server 2000. The fact table contains about 2.5 million rows. There are five side tables, the largest having about 80K rows. All joined fields are indexed. When the actual database is created, I expect the fact table to grow to as many as 50 million rows. Can any one tell me at what size to expect the performance of SQL server performance to degrade?

 

[SQLBill]

I think it will be hard for you to get an accurate answer to your question. There are too many factors...what is your database like? How much memory? How many processors? How often is data being inputted? How often are queries run? ETC., ETC.

For example:

I'm using SQL Advanced Server 2000 which is on a DELL 2-node cluster using a shared drive with 313 GB of memory and having 4 processors.

I currently have over 152 million rows of data. Data is inputted in bulk inserts every 30 seconds (10 to 40 rows). Queries are done about every hour.

There isn't any performance loss on my database and I don't expect any for a very long time.

-SQLBill

 

[scotward]

Thanks. I think you answered my question. We haven't decided on hardware yet. The prototype currently recides on a desktop and runs quite well. It sounds like you are saying that performance issues can be managed through hardware considerations and database configuration. Basically, SQL server will be a reliable platform for our warehouse as long as the database is built properly.