Hi All,
When I try to process my mail with xp_findnextmsg or xp_readmail or xp_sendmail i get these errors:
Server: Msg 18025, Level 16, State 1, Line 0
xp_findnextmsg: failed with mail error 0x80004005
Queries processed: 0.
Server: Msg 18025, Level 16, State 1, Line 0
xp_readmail: failed with mail error 0x80004005
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
my configuration is:
ms sql 2000 sp3
outlook 2003 as mapi client
sql server is started under account for which mapi profile is configured
Does anyone know what is wrong, and how to solve this problem?
Thanksdid you check eventviewer application and system error logs? do you get any errors while using outlook directly on the box?|||i've found what was the problem. When outlook started it deny acces to personal folders file (*.pst) for any other programm or process. And in normal way when I close outlook it should "release" that file, but that not happend. So now before processing mail i have to run xp_stopmail procedure, in other way mail processing will not be possible. And by the way in sql server error log i have these errors
2004-01-31 12:09:40.59 spid59 Error: 1073759806, Severity: 1, State: 0
2004-01-31 12:09:40.59 spid59 Starting SQL Mail session...
2004-01-31 12:09:40.60 spid59 Error: 1073759778, Severity: 1, State: 0
2004-01-31 12:09:40.60 spid59 SQL Mail session started..
on microsoft tech net they say :
These are informational (severity = 1) messages due to starting SQL Mail with xp_startmail. With SQL Server 2000, SQL Mail automatically starts when you run xp_sendmail, so use of xp_startmail is not necessary. You can ignore these messages.
thanks
Showing posts with label process. Show all posts
Showing posts with label process. Show all posts
Wednesday, March 7, 2012
Mail processing problems
Labels:
database,
errorsserver,
level,
line,
mail,
microsoft,
msg,
mysql,
oracle,
process,
processing,
server,
sql,
state,
xp_findnextmsg,
xp_readmail,
xp_sendmail
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
> to.)
>> I need to get SQL server to receive certain mail and process it directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to test,
>> but there's none their. The server is question has a mail profile set up
> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
> lost.
>> Thanks in advance,
>> NEIL
>>
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2fwc091301%2fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Neil,
>> You need to link a MAPI profile to the SQL Server Agent service account.
>> Log
>> on to the server as the SQL Server service account, configure Outlook,
>> and
>> restart your services. You should now see the mail profile in the SQL
>> Server
>> Agent properties dialogbox.
>> Jon Jahren
>> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
>> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
>> to.)
>> I need to get SQL server to receive certain mail and process it
>> directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to
>> test,
>> but there's none their. The server is question has a mail profile set up
>> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
>> lost.
>> Thanks in advance,
>> NEIL
>>
>>
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
> to.)
>> I need to get SQL server to receive certain mail and process it directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to test,
>> but there's none their. The server is question has a mail profile set up
> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
> lost.
>> Thanks in advance,
>> NEIL
>>
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=http%3a%2f%2fsupport.microsoft.com%2fservicedesks%2fwebcasts%2fen%2fwc091301%2fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> Neil,
>> You need to link a MAPI profile to the SQL Server Agent service account.
>> Log
>> on to the server as the SQL Server service account, configure Outlook,
>> and
>> restart your services. You should now see the mail profile in the SQL
>> Server
>> Agent properties dialogbox.
>> Jon Jahren
>> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
>> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> (Sorry for the over-zealous cross posting - not sure which one to post
>> to.)
>> I need to get SQL server to receive certain mail and process it
>> directly.
>> If I go to SQL Mail in EM, properties it asks for a profile name to
>> test,
>> but there's none their. The server is question has a mail profile set up
>> so
>> I can read my email, so what do I do now?
>> Am I in the right plcae anyway? Never done this before, so completely
>> lost.
>> Thanks in advance,
>> NEIL
>>
>>
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEIL
Neil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/default...b;en-us;263556
--
Peter Ward
WARDY IT Solutions
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>
|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>
|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=h...fwct091301.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Mail help
Hi,
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/defaul...kb;en-us;263556
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=...130
1.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
(Sorry for the over-zealous cross posting - not sure which one to post to.)
I need to get SQL server to receive certain mail and process it directly.
If I go to SQL Mail in EM, properties it asks for a profile name to test,
but there's none their. The server is question has a mail profile set up so
I can read my email, so what do I do now?
Am I in the right plcae anyway? Never done this before, so completely lost.
Thanks in advance,
NEILNeil,
You need to link a MAPI profile to the SQL Server Agent service account. Log
on to the server as the SQL Server service account, configure Outlook, and
restart your services. You should now see the mail profile in the SQL Server
Agent properties dialogbox.
Jon Jahren
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Neil
The following article on how to configure SQL Server Mail may be of
assistance:
http://support.microsoft.com/defaul...kb;en-us;263556
--
Peter Ward
WARDY IT Solutions
--
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||If you want to process E-Mail directly, you need to set up SQL/Server Mail,
NOT SQL Agent Mail.
Mike A.
"Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Neil,
> You need to link a MAPI profile to the SQL Server Agent service account.
> Log
> on to the server as the SQL Server service account, configure Outlook, and
> restart your services. You should now see the mail profile in the SQL
> Server
> Agent properties dialogbox.
> Jon Jahren
> "Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
> news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> to.)
> so
> lost.
>|||Thank you all gentlemen - I will digest these later!
NEIL
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:cn9sn6$896$1$8302bc10@.news.demon.co.uk...
> Hi,
> (Sorry for the over-zealous cross posting - not sure which one to post
to.)
> I need to get SQL server to receive certain mail and process it directly.
> If I go to SQL Mail in EM, properties it asks for a profile name to test,
> but there's none their. The server is question has a mail profile set up
so
> I can read my email, so what do I do now?
> Am I in the right plcae anyway? Never done this before, so completely
lost.
> Thanks in advance,
> NEIL
>|||Here is also a good article for troubleshooting when you run into
problems...
http://support.microsoft.com/?scid=...130
1.asp
"Michael Abraham" <mabraham@.decisionarc.com> wrote in message
news:Ou0S4LyyEHA.2568@.TK2MSFTNGP11.phx.gbl...
> If you want to process E-Mail directly, you need to set up SQL/Server
> Mail, NOT SQL Agent Mail.
> Mike A.
> "Jon Jahren" <jon.jahren.fightspam@.sqlkompetanse.no> wrote in message
> news:euPW3NwyEHA.2600@.TK2MSFTNGP09.phx.gbl...
>
Monday, February 20, 2012
LSASS.EXE high CPU usage
I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.
Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>
|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.
Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>
|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>
LSASS.EXE high CPU usage
I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> > I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
> serious
> > problem.
> >
> > Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
> usage
> > to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
> The
> > consequence of course being that the server goes to a constant 100% CPU
> > usage, causing services to be denied or be unacceptably slow. During
> normal
> > operation (when LSASS is behaving), the server spec is more than enough to
> > cope with it's workload, and runs at around 20% CPU usage.
> >
> > There were issues with LSASS.EXE in Win2k, but none that I know of or can
> > find in Win2k3. This is not a SASSER type worm virus, it's genuine
> LSASS.EXE.
> > I'm not even sure if this is the cause of the problem or a symptom of
> > something else.
> >
> > Please suggest something, this is a critical production server and this
> has
> > now become a serious issue.
> >
> > Thanks.
> >
> >
>
>
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> > I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
> serious
> > problem.
> >
> > Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
> usage
> > to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
> The
> > consequence of course being that the server goes to a constant 100% CPU
> > usage, causing services to be denied or be unacceptably slow. During
> normal
> > operation (when LSASS is behaving), the server spec is more than enough to
> > cope with it's workload, and runs at around 20% CPU usage.
> >
> > There were issues with LSASS.EXE in Win2k, but none that I know of or can
> > find in Win2k3. This is not a SASSER type worm virus, it's genuine
> LSASS.EXE.
> > I'm not even sure if this is the cause of the problem or a symptom of
> > something else.
> >
> > Please suggest something, this is a critical production server and this
> has
> > now become a serious issue.
> >
> > Thanks.
> >
> >
>
>
LSASS.EXE high CPU usage
I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a seriou
s
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE
.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>
s
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE
.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>
Subscribe to:
Posts (Atom)