sysperfinfo gives you the memory used by SQL Server.

There is an utility pslist.exe which shows exactly same as task manager. You can run it within QA with xp_cmdshell to...

Could it debug be turned on?

http://support.microsoft.com/default.aspx?scid=kb;en-us;328151

Enable 'text report' by going plan properties --> reporting tab --> check 'write report to a text file ...', rerun the job --> review the text report to see any...

I guess you choose 'database integrity check' option with 'attempt to fix any minor error' in your maintenance plan, Can you comfirm that?

How do you perform the backup? If it is SQL Server backup with backup database command, It doesn't matter whether you have users connecting to the database.

What error message...

Check SQL Server errorlog to see message like "Performance monitor shared memory setup failed: -1". If you do, you need hotfix.

http://support.microsoft.com/default.aspx?scid=kb;en-us;812915

Which SQL Server version and service pack do you run?

...

See http://support.microsoft.com/default.aspx?scid=kb;en-us;270119

Which SQL Server version and service pack do you run? How did you create the proxy account, from EM or sp?

Edited by - allen_cui on 08/07/2003 06:31:44 AM

I would suggest you to look at third party products from http://www.lumigent.com.

Read BOL by looking for key word "MS DTC" and you will find out what is "Distributed Transaction Coordinator" and hwo/when to use it.

Quoted from BOL.

"Parallel Query Processing

Microsoft® SQL Server™ 2000 provides parallel queries to optimize query execution for computers having more than one microprocessor. By allowing SQL Server to perform a query...

Try to generate text report from maintenance plan properties --> reporting tab, run the job and review the text report.

Did you use machine name as the domanin name when creating the proxy account?

quote:

---

I needed to load one SQL Server 6.5 database into SQL Server 2000.

---

You...

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;296769