Causes for SQL Server Stack Dump.

Can anyone tell the general cause for sql server to generate an stack dump.
And how important it is to analyze the dumps generated.
ThanxHi
The highest number of causes for stack dumps is hardware related, therefore
it will be hard to tell what has caused yours unless you analyse the dump. If
you are running a business critical system then I would certainly want to get
to the root cause. You may want to raise a call with PSS to get it analysed.
John
"Ramesh" wrote:
> Can anyone tell the general cause for sql server to generate an stack dump.
> And how important it is to analyze the dumps generated.
> Thanx|||Actually, that is the only way to analyze a stack dump. PSS has the symbol
files to load up to the stack dump.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:41840968-4106-43B5-A73F-7639B990B5CE@.microsoft.com...
> Hi
> The highest number of causes for stack dumps is hardware related,
> therefore
> it will be hard to tell what has caused yours unless you analyse the dump.
> If
> you are running a business critical system then I would certainly want to
> get
> to the root cause. You may want to raise a call with PSS to get it
> analysed.
> John
> "Ramesh" wrote:
>> Can anyone tell the general cause for sql server to generate an stack
>> dump.
>> And how important it is to analyze the dumps generated.
>> Thanx