One question for you... Dont you want to keep the records for historical purpose?

You were quicker on...

There are couple of Options for you that comes to my mind.

1. Look at Table Partitioning

2. Instead of deleting from table, insert into another table with the last 7 days...

If the connection is being refused at the database level you will see the error details in the error log of the DB.

Also check Select @@servername and see if...

Do you see anything in your error log?

Are your tables normalized? I am just wondering why you would have single table with 25 gig of data for just one year.

I think your best option is to go...

In SQL 2008 the TempDB usuage is very high compared to SQL 2000. If your disks are not configured properly you might find some IO bottlenecks. Couple of other thing...

The DB server, is it hosting only the Database or does it have other applications as well? You could probably be experiencing IO bottleneck. Not sure though...

Hi David,

It depends on your queries. Let us say you always query from a table in specific order for example desc, then at the time of execution, the sort operation...

I second Wayne on that.

Have you looked up on Indexed views? here is a bit that might interest you about indexed views. (taken from MSDN)

* Aggregations can be precomputed and...

Are the servers in the same domain?

Also if you do a nslookup Servername from command prompt what do you get?

Can you ping or telnet to the servers with...

Warehousing is probably where you have to go to. Does the data change for Old records? If not why not have a pre populated summary table? You can have a...

Did you by any chance look at the execution plan? There are lots of reasons why the performance could differ between your test and production.

Do you take care of...

David Lester (2/4/2010)

---

The one thing on performance which I wish could be done, would be a guideline of what to 'expect' from a server. ie 100,000 records per second transfers,...