Could you please shar that script, I am in need of it.

Thanks,

MJ

Moin,

Check http://www.sqlservercentral.com/articles/Administration/2582/

Manu

The example below transfers ownership of the Database Mirroring endpoint to ‘sa’:

USE master

GO

ALTER AUTHORIZATION ON ENDPOINT::Mirroring TO [sa]

GO

Did you get a chance to try wht I suggested?

MJ

What is the size of larget index present in the database?

MJ

Save output of following query and go for password change for sa.

Query 1:

select password,name from master.dbo.sysxlogins

where name='sa'

In case, u need to reset it use the below mentioned code(All at...

Take frequent log backups if that is the case and rebuild indexes one by one and only if its needed(for e.g. frag.>30 and indx pages >1000 or so).

It will release it only if required(for example, OS starving for memory --Experts plz comment).

To monitor memory usage use DBCC Memorystatus(http://support.microsoft.com/kb/271624).

Also, DMV named 'sys.dm_os_memory_clerks' could be used too.

MJ

Refer-->http://msdn.microsoft.com/en-us/library/aa239422(SQL.80).aspx

I think you just want to install client components.

http://msdn.microsoft.com/en-us/library/ms143219.aspx

MJ

If you are considering a single query then try out using MAXDOP hint if that helps.

MJ

If inserts are slowing down then as suggested above check for indexes on base tables. They must be useful and any uncecessary/duplicate indexes needs to be dropped.

Unless there is any auditing solution in place or table has any such date columns its difficult to fetch that.

MJ

As per http://www.sql-server-performance.com/faq/domain_controller_performance_p1.aspx

1.

While SQL Server can run on a domain controller, it is not recommended if you are seeking the best performance. For best performance of SQL Server,...

Trace flag referred to by Steve should work in 2005 as per http://www.mssqltips.com/tip.asp?tip=1457

MJ