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
Issue:
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