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

1. How can I tell how much memory SQL Server is allocating and using?

There are specific performance counters like sql server memory : ...

another free commandline utility is 7-Zip

http://www.7-zip.org/

At busy-server times I use Query Analyzer instead of EM which tends to lock up at such moments.

sp_who2: show current connections

DBCC INPUTBUFFER (spid): show sql-query

It has also a schema-browser (tools->Object...

I see other things running on the server, such as mssearch.exe (Mem usage 52,352 K), so it would be good to get advice about what services can be safely turned...

Hello,

I haven't worked with servers >2gb yet.

But found a great link about how sql server deals with memory:

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

So my questions are:

1. Does the quoted advice above mean I should...

Are the database files excluded from the antivirusscanner?

BACKUP DATABASE testdb

TO DISK='\\ServerB\Backup\ServerA\testdb.bak'

*Make sure the executor (sql agent) has enough permissions on the disk

*Try to restore at least one backup. We had issues with windows 2003 without servicepack &...