As long as he has 'securityadmin' server role, he should be able to add new logins. Any error message when tring to add logins?

You need grant that user with 'db_accessadmin'...

The spid 20 could be in 'rollbak' status but spid 80 should ne killed immediately if it is select statement only.

There is no way to know the memory consumption on each database as I konw if multiple databases are in same instance. The performance monitor porvides memory usage at instance...

Are you copied information to the file system or database in another server? Is SQL Server Agent run by local system account?

You can setup SQL Server Agent Proxy Account that...

You are in right track to uninstall and reinstall SQL Server to the second node. What you need to do after that is to reinstall SQL Server service pack and...

I am not SAN expert but there is a trend to place database/files to SAN for better performance in storage subsystem. The SAN drivers have to be configured as local...

Use the affinity mask option to increase performance on symmetric multiprocessor (SMP) systems (with more than four microprocessors) operating under heavy load. You can associate a thread with a specific...

Since same problem happens to few of your servers, I would recommend you to configure the registry to one of servers to see whether same issue occurs again. Or go...

Need some examples.

How do you create table dynamically? What is database recovery model and how do you backup database transaction log? Rebuild indexes will increase the transaction log usage, if you backup/truncate...

Don't quite understand your reply. Can you provide the answers to my questions?

Reconfigure memory allocation to these two instance may help improve the performance, for example, give less memory...

Ok, I have seen this problem happening to backup/restore large databases in my environment. We fixed it by following Microsoft KB http://support.microsoft.com/default.aspx?scid=kb;en-us;304101&Product=win2000.

I just had similar problem few days ago when...

Run performance monitor to verify how much memory has been allocated to each instances. The query running fast in the instance with one database may due to all data the...

Do you see any backup related error messages in SQL Server errorlog, for example, "Insufficient system resources exist to complete the requested service."? How large is your database? Which Windows...

What is the size of largest table in your database?