My system configuration is like this
4 GB Ram and 2 instances are running on the box
1.SQL 2000 Server 2.SQL 2008 server
Max Memory configuration for servers is 1500 for SQL Server 2000 and 1500 SQL Server 2008
One database is going to suspect mode always, if I run sp_who2 I see the transaction roll back transaction is not completed still running
If I restart the system database is working,
Question: database suspect occurs due to insufficient memory ?
Please suggest me the Max memory configuration for both servers
Please suggest me when I install a SQL Server 2008 servers do I have to Add account in Lock Pages In memory.
Please suggest me how to find out memory issues key counters to look and preferable values..
Please let me know.plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz