Hello,

The latest articles recommend watching I/O latency performance counters instead of

queue length.

The high queue length can come of various reasons:

datagrowth, recent software update.

Have a look at

http://www.sql-server-performance.com/articles/audit/main.aspx (performance audit)

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

for...

Access saves the tabledefinition when it is first linked.

Any change in the defintion may result in #deleted entries or not showing additional columns.

Some access-programs have vba-code that drop the old...

It surprises me too.

In the definitions where-clause of the view is

where permissions(831458882) & 1 = 1

Still have to decipher that.

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...