March 4, 2005 at 4:23 pm
What are your server configuration parameters, can you describe more about the machine & sql server installation you are working with. We had this happen, and it was due to the fact that the mem-to-leave space is too small by default. On installation, the mem-to-leave space is 256 MB. Mem-to-leave is the place where out of process programs will run on your sql server. You can specify the size of mem-to-leave, with the -g startup parameter. SQL Server Books online has more information about this. You need to experiment with the exact setting suitable for your system; you could probably go to 384 or 512 with no issues.
March 4, 2005 at 5:17 pm
Thanks for the info
I will try the -g. I think this make sense based on BOL since one of the areas failing is SQLMail which needs to load a .dll. I also noticed that this severs SQL Server is configured to use all of the pysical memory. That does not seem right, since there are other processes that have to run on the server. I guess more is not always better. I reduced this to use about 80%. We will try rebooting with the new parameters this evening and cross our fingers that everything seems better Monday. I am really more of a programmer than a DBA, but when problems come up I still have to deal with them.
March 15, 2005 at 1:05 pm
Did that work ?
Thanks in advance.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply