July 10, 2006 at 12:26 am
Hi,
Sometime I am receiving this message in all articles. "No enough storage is available to process this command". Physically there is no such disk space & memory issues in the server but the problem gets solved when I restart the server. Any idea about this thing?
Thanks, GOVIND
July 10, 2006 at 12:53 am
can you provide some config info ?
SQLServer version and sp
Server OS and sp
Memory
If you can reproduce this or know the interval this recurs, start profiler to capture which load is thrown to your server.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 11, 2006 at 9:45 am
Can you post the exact error message?
I can think of two things that might do what you are talking about:
1. Using XML in queries incorrectly. This will definitely cause the problem.
2. Using OA_xxxxx sprocs incorrectly to interoperate with COM objects. Not sure on this, but I think it might apply.
Both things will work OK but not doing it "just right" might cause the symptom that you describe. The storage referred to in the message probably refers to a special place in memory that and has nothing to do with how much RAM or disk space you have.
jg
July 11, 2006 at 9:40 pm
Hi All,
sorry for late reply, I will try to reproduce the same error again and I will post the agent's output text. Jeff, I am not using XML in queries neither interoping COM objects, just simple plan T-SQL.
The server physical hardware is : 3 GB RAM, 20 GB (FREE SPACE) HD, 2.0 Ghz Xeon (Dual processor). I will reply soon for more info, thanks again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply