I guess testing of tool performance should not be based on the fregmentation. The reason is that index fragmentation is always vary through out the day due to many DML....

Is this interview question?

Find additional link with reference to this:

http://blogs.msdn.com/b/chrissk/archive/2010/01/05/troubleshooting-sql-maintenance-plan-message-sqlstate-42000-error-22029.aspx

http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx

HTH

Many people face this issue including myself. The issue would be with the Maintenance JOB creation. Check in delete backup location and extention of file should be trn

HTH

Try using SQL Server authentication. Refer following link for further detail:

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

HTH

You can use perfmon tool; refer the following link for further details:

http://calegp.com/?p=550

HTH

What is the error message? Do you have proper credentials for linked server and/or local machine?

What is transactions/sec on your server/database?

SQL Server Profiler is the best tool to use. You can use respective filters as per your requirement. However just keep in mind that Profiler is resource consuming and avoided...

I have double checked and working fine. I am able to set 90 min. without any issue.

Yes, Grant Fritchey's books on performance tunning are good and best to start for performance tunning.

Which window service?

Cody K (3/25/2014)

---

Gila,

Why did statistics need to be updated when attaching to the new version of SQL Server? I did a little googling but couldn't find a reference for it....

It depends. What is the size of data?

What if 1000 PROC is replicating? Need to edit 1000 PROC?