some DMVs can impact overall system performance.

these are few of them.

sys.dm_os_schedulers

sys.dm_os_workers

sys.dm_os_threads

sys.dm_os_tasks

sys.dm_os_waiting_tasks

sys.dm_os_ring_buffers

Reference : http://sqlblog.com

why dont you try mapping the servers?

Here you go.

Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager.

select the SQL Server service that you want to set the startup parameters.

right click and select "Properties"

go...

Check this link for complete info on BUILTIN/Administrators

http://www.sqlservercentral.com/articles/Security/sqlserversecuritysecurityadmins/1031/

you can use "Microsoft Assessment and Planning Toolkit" , free tool from microsoft.

the tool scans the computers based on a file with list of computer names or a range of...

Run DBCC FREEPROCCACHE to clear out the cache.

These are some of monitoring tools

SQL server DBA Dasboard - Microsoft

DB Artisan - Embarcadero

Performance...

so far this is the only issue.

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/18/my-latest-sp3-experiences-two-thumbs-acting-like-divining-rods.aspx

its not too early....we already installed sp3 on our production servers

and yes its 9.00.4035.00 after installation

I faced this issue once....and thats bcos i had no SP2 on one node of the cluster.It was solved after installing sp2.

check this

http://www.sqlservercentral.com/Forums/Topic459626-146-1.aspx

DBCC TRACEON(1204,1222)

1204 - This trace flag reports deadlock information formatted by each node involved in the deadlock

1222 - This trace flag formats deadlock information, first by processes and then by...

a sql server 2005 can have 1 default instance and 50 named instances.There is no such limit for db`s as far as i know.

Now the question is size of the...

sp_helprevlogin

also check for orphaned users when you are done.