Search Results | SQL Server Performance Forums

Server crashes with 'Insufficent Memory'

Post by: stanle, Dec 14, 2002 in forum: Performance Tuning for DBAs

To the previous post:I have just one SQL instance installed. By this moment I haven't reproduced the error with the new settings applied and I hope...

Server crashes with 'Insufficent Memory'

Post by: stanle, Dec 11, 2002 in forum: Performance Tuning for DBAs

Hi Brad, apparently you're the only one taking this problem seriously. I really appreciate your help. The hints you've given me so far are good and...

How much RAM is enough per client?

Post by: stanle, Dec 10, 2002 in forum: Performance Tuning for Hardware Configurations

If UFOBIX wants to stick to the NT4 environment, and is certain that the 2GB aren't enough, then he can upgrade the RAM to 4GB and install a second...

Server crashes with 'Insufficent Memory'

Post by: stanle, Dec 10, 2002 in forum: Performance Tuning for DBAs

/PAE /3GB are in the boot.ini sp_configure returns: affinity mask-2147483648214748364700 allow updates0100 awe enabled0111 c2 audit mode0100 cost...

SQL Replication

Post by: stanle, Dec 9, 2002 in forum: Please Tell Us What You Think

Replication is a very interesting part of the SQL Server in terms of performance issues. It can easily become a topic for a new forum. I totally...

How much RAM is enough per client?

Post by: stanle, Dec 9, 2002 in forum: Performance Tuning for Hardware Configurations

You can't use more anyway with this platform. 2GB is the max NT4,SQL7 can use.

How much RAM is enough per client?

Post by: stanle, Dec 9, 2002 in forum: Performance Tuning for Hardware Configurations

Can you be more specific? If I had to guess, then I would assume that you are asking about the "Minimum Memomory Per Query" setting (it is in the...

Slow running Query

Post by: stanle, Dec 9, 2002 in forum: T-SQL Performance Tuning for Developers

It can be the compiled plan. If the sp is reading data from frequently updated/inserted tables, then you have to recompile it from time to time. A...

Server crashes with 'Insufficent Memory'

Post by: stanle, Dec 9, 2002 in forum: Performance Tuning for DBAs

10x for the help Chappy. Yes, it is a dedicated SQL server. It is also a distributor and other processes that take memory are the distrib jobs...

Server crashes with 'Insufficent Memory'

Thread by: stanle, Dec 9, 2002, 9 replies, in forum: Performance Tuning for DBAs

I am posting a part of the log that describes our error. The configuration is 8 processors, 8GB memory, AWE enabled. The server crashes (hangs) after...