Select AcctNbr,SubAcctNbr

from dbo.AcctEntry --> has 700,000 rows

Could be a full table scan or an index scan (on AcctNbr,SubAcctNbr)

Fast server:

Could have had those data in cache before (more memory)

Could have an...

*be aware that SP4 needs a hotfix if you are using AWE-memory parameters

*SP4 has a behaviour change in deciding which index to use. With comparisions you have to match the...

The only thing I had to change on replication was the batch-size used by the agents because of a slow subscriber.

Have a look at the performance counter sql server target memory.

http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx

A restore normally restores permissions also.

Are you restoring to a single-user mode (restricted) or multiuser?

I had problems with permissions not being restored in restricted mode (only dbo permissions remained).

Can you find the specific error?

It only starts deleting files after all the backups were succesfull.

is a hard limit in msde 2000

http://www.petefreitag.com/item/194.cfm

sql server 2005 express doesn't has that limitation

http://databases.aspfaq.com/database/what-are-the-limitations-of-msde.html

Can you connect from server A using the ip address only (not by alias)?

It only starts deleting files after all backups are done succesfully. Do you have ample free space?

Is there a reindexing/rebuild/shrink operation going on the database?

You can find the current connections using the stored procedure sp_who2.

You can also start a trace with the profiler to monitor the...

The ping is a good start.

1) Is there a firewall running?

2) Can you connect to your MSDE using query analyzer on another machine (not using the linked server name). Sql...

That's odd. Normally the lesser the logical reads the merrier.

*Did you use DBCC FREEPROCCACHE to clear the execution plans?

*A stored procedure can be slower than a regular query because of...

Does a regular remote connect works (not as linked server)?

Have a look at

http://support.microsoft.com/kb/319892

Hello, I'm deprived of my sql installation for the moment, so this is from memory.

Memory: Pages/sec

9/15/2007 97.885

10/8/2007 24.389

10/15/2007 520.3

Is quite high. If it only spikes briefly at certain moments, it...