Jeff

Thanks for the advice. These 4 hours are our maint window where there is no activity other than the backup and index routine.

Before I started here (2 weeks ago) the...

Without knowing what your system does and the amount of transaction your process it is hard to advise.

But I will try with what I have implemented.

Every evening (11pm) I run...

Hi

Check this MS artical

http://support.microsoft.com/kb/920114/en-us

Rgds

JL

Are you using merged, transactional, transactional with sub updates, P2P or snapshot?

JL

Hey

My SAN env is as follows

D: contains the MDB which is Raid 6 (dont ask it was in before I started, but will soon be changed).

E: contains the LDF which...

1. Open replication monitor

2. Select the server your publication is on (if you have more than one)..

3. Click on the publication.

4. Click on the "Warnings" tab. and adjust the...

Hi

Which type of replication are you using?

The link below shows you the support type and editions.

http://msdn.microsoft.com/en-us/library/ms143241(SQL.90).aspx

JL

Hi

Below is a MS article with instructions on setting this up.

It could be that you proc cache is catching up.

When there service /server is restarted the proc is cleared, therefore when the SP/queries are run for the 1st time performance...

Hi

Thanks for the reply.

If I am updating 3-4 tables using the TOP function, will added the BEGIN TRANSACTION outside the WHILE Loop cause an issue?

Rgds

JL

Hi

There are a few articles on here that should get you started.

http://www.sqlservercentral.com/articles/Monitoring/61373/

you can also change the script to include memory info and any other info you require.

Pretty cool,...

What is the exact code you are using.

Normally it is just...

sp_dropserver old_servername\instancename

GO

sp_addserver new_servername\instancename, local

GO

220 is just that a connection has been made.

You need to try sending a mail. This will test relaying and a SMTP send.

http://www.amset.info/exchange/telnet-test.asp

If you can do this...

Maybe the link below will help...

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/f572e698-f5fc-4f1f-950f-9c5cf1cb24a8

Can you telnet to the smtp server from the SQL server

telnet server.domain.com 25

helo" enter

mail from: your Email Address enter

rcpt to:"recipient address" enter

data enter

enter . enter