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

Quite a coincidence, I went to a Oracle 11g launch presentation today.

you're welcome

sql-server-performance has a nice list of articles for setting a baseline / performance

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

Buffer cache hit ration 99% -> OK no more memory is needed, otherwise the cache wouldn't maintain 99%...

Do you have a backup of msdb?

There was an I/O error in the past that caused the torn page

Torn_page_detection:

This recovery option allows SQL Server to detect incomplete I/O operations caused...

*the @@Servername could still point to an older name, it doesn't autoadjust to the wins name.

at http://www.databasejournal.com/scripts/article.php/1496451

you can find a script that resets it to its wins name

sp_dropserver ...

sp_addserver ...

restart

*depending...