Examining event logs hangs Enterprise Manager

Anyone know a reason why trying to read the event logs hangs Enterprise Manager?
Do I have to read them threw Enterprise Manager?
Thanks,
Bryan HughesCheck to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.|||Originally posted by Pigeon
Check to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.

Now for the $60,000 question, where do I find the SQL Server event logs...|||Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

blindman|||Originally posted by blindman
Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

blindman

The command is : sp_cycle_errorlog

Default path where you would find the logs is the Logs directory in your MS SQL installation folder|||Were you talking about the event logs or the sql server logs ? If your sql server log is really big then will experience the "hang". If you don't know the location, just do a quick search on ERRORLOG.|||Thanks Enigma. Did you consult the Holy Book? ;)

blindman :cool:|||Nope .. but did see the code for sp_cycle_errorlog.
And found out an undocumented dbcc command (not there in the Holy Book)

dbcc errorlog|||Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman|||Both cycle the log.|||Originally posted by blindman
Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman
Well .. the code for the stored proc sp_cycle_errorlog is :

create procedure sp_cycle_errorlog -- 1997/06/24
as
if (not (is_srvrolemember('sysadmin') = 1)) -- Make sure that it is the SA executing this.
begin
raiserror(15247,-1,-1)
return(1)
end

dbcc errorlog
return (0)

So ultimately its dbcc errorlog that is recycling the logs|||Thanks for the help! You guys rock...|||Originally posted by blindman
Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman

How can you see it if you're a blindman?

I thought you were answer questions from a brail monitor or something...

and DUDE...where's the dark planet?|||My seeing eye dog translates text from the screen into a series of binary woofs indicating the ASCII codes of the characters. And ever since Enigma changed his Icon, Fido keeps trying to bury my monitor in the back yard.

Bad DOG!

blindman|||The Dark Planet is a dark corner of the Milky Way Galaxy.

LOL :GRIN:

BTW if you want to know where I am from ... I am from Mumbai , India|||To paraphrase Churchill, do you contain a riddle wrapped in a mystery?|||Only thing I would say .. I am a puzzle in myself...

eventvwr.msc message

I keep getting this message in the event viewer -- how can I uninstall reportserver ?
Event Type: Information
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 17137
Date: 10/22/2006
Time: 10:49:57 AM
User: NT AUTHORITY\NETWORK SERVICE
Computer: ********************
Description:
Starting up database 'ReportServerTempDB'.I'm not sure about SQL Express, but on the SQL 2005 installer you can launch
the uninstall from the Add/Remove Programs select change and during the
uninstall select what component (Reporting Services) you would like to
uninstall.
Steve MunLeeuw
"Jon Paal" <Jon[ nospam ]Paal @. everywhere dot com> wrote in message
news:uhJBURg9GHA.1168@.TK2MSFTNGP03.phx.gbl...
>I keep getting this message in the event viewer -- how can I uninstall
>reportserver ?
> Event Type: Information
> Event Source: MSSQL$SQLEXPRESS
> Event Category: (2)
> Event ID: 17137
> Date: 10/22/2006
> Time: 10:49:57 AM
> User: NT AUTHORITY\NETWORK SERVICE
> Computer: ********************
> Description:
> Starting up database 'ReportServerTempDB'.
>
>

Events Calendar Questions: how to find events in the week end

I have a start date, end date for each event.

I want to list all events between the start and end date comes in Saturday or Sunday.
in SQL server 2005 TSQL statement.

any insights ?Below is a link to an article that explains how to manipulate Dates in SQL and gives a good description of the DATENAME command which you will most likely need to use for this.

http://www.quest-pipelines.com/newsletter-v3/0202_G.htm

I hope that this helps.

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:312
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
Event Type:Information
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:311
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Attempting to to re-open the local eventlog...
Event Type:Error
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:318
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
>
|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:

> It's chicken and egg. The reason you get the messages is because you cleared
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you will
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
>
>

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
----
--
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 312
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
----
--
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 311
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Attempting to to re-open the local eventlog...
----
--
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
----
--It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
--
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
--
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
--
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
--
>|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:

> It's chicken and egg. The reason you get the messages is because you clear
ed
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you wil
l
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
>
>

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
----
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 312
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
----
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 311
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Attempting to to re-open the local eventlog...
----
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
----It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
>|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:
> It's chicken and egg. The reason you get the messages is because you cleared
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you will
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> > Each time I clear the event log on two of our SQL servers, I get the
> > following errors a few seconds later (see below). Config is as follows:
> > Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> > servers).
> >
> > Any help in clearing up these annoying error messages would be
> > appreciated.
> >
> > ----
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 312
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Successfully re-opened the local eventlog - NOTE: Some events may have
> > been
> > missed.
> > ----
> > Event Type: Information
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 311
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Attempting to to re-open the local eventlog...
> > ----
> > Event Type: Error
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 318
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Unable to read local eventlog (reason: The event log file has changed
> > between read operations).
> > ----
> >
>
>

Eventlog replication queue is full

I keep receiving the warning message in the event viewer
that the Eventlog replication queue is full.
Error:
EventLog replication queue OUTQ is full. 3 event(s) is
(are) discarded of (total) size 2612.
What should I do to resolve this error?
Thank You,
Dan
Assuming the actual message is "Event Log replication queue OUTQ is full.",
see:
283078 Event Log Replication on Cluster Node Generates Event ID 1137
http://support.microsoft.com/?id=283078
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

eventlog

my system W2000+ SQL7.4
why I am getting 3 messages on the eventlog ?
Source: SQLServer/Agent
Category: Alret Engine
Event ID : 319
Unable to read local Event Log ( reason: The event log
file changed between read operation
Source: SQLServer/Agent
Category: Alret Engine
Event ID : 311
Attempting to to re-open the local eventlog..
Source: SQLServer/Agent
Category: Alret Engine
Event ID : 312
Successfully re-opened the local eventlog - NOSomeone cleared the event log and sql agent lost it's original handle to
that file and had to grab a new one. It's normal and nothing to worry
about.
--
Andrew J. Kelly
SQL Server MVP
"glik" <agrolan@.agrolan.co.il> wrote in message
news:01b401c34b66$499c3ff0$a001280a@.phx.gbl...
> my system W2000+ SQL7.4
> why I am getting 3 messages on the eventlog ?
>
> Source: SQLServer/Agent
> Category: Alret Engine
> Event ID : 319
> Unable to read local Event Log ( reason: The event log
> file changed between read operation
> Source: SQLServer/Agent
> Category: Alret Engine
> Event ID : 311
> Attempting to to re-open the local eventlog..
> Source: SQLServer/Agent
> Category: Alret Engine
> Event ID : 312
> Successfully re-opened the local eventlog - NO

EventId : 11708 : setup MSDE Rel A with Windows 2003 + TS application mode

Hello,
Impossible to setup MSDE release A (with sp3a) on a windows
2003 standard, with TS in application mode installed.
Event ID : 11708
Setup SQL Server failed
Anyone an idea ?
Thanks a lot
hi,
baurin wrote:
> Hello,
> Impossible to setup MSDE release A (with sp3a) on a windows
> 2003 standard, with TS in application mode installed.
> Event ID : 11708
> Setup SQL Server failed
> Anyone an idea ?
> Thanks a lot
please have a look at http://support.microsoft.com/?kbid=317268 and
http://support.microsoft.com/?kbid=830629
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Very good answer, all is ok now.
>--Original Message--
>hi,
>baurin wrote:
>please have a look at
http://support.microsoft.com/?kbid=317268 and
>http://support.microsoft.com/?kbid=830629
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
>DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE
2000 a visual
>interface)
>-- remove DMO to reply
>
>.
>

Event_id 6008 - Unexpected Reboot

I have a Windows 2000 SP4 server running SQL Server 2000
Enterprise Edition that continually gets an event 6008
(the previous shutdown was unexpected). I also get the
following bugcheck and memory error. Does anyone know
what these errors are and how to correct them? Thanks.
Event Type:Information
Event Source:Save Dump
Event Category:None
Event ID:1001
Date:9/24/2004
Time:11:38:37 AM
User:N/A
Computer:UHDSSAPPSERV
Description:
The computer has rebooted from a bugcheck. The bugcheck
was: 0x000000d1 (0x8d0ee101, 0x00000002, 0x00000000,
0x8d0ee101). Microsoft Windows 2000 [v15.2195]. A dump was
saved in: C:\WINNT\MEMORY.DMP.
Event Type:Information
Event Source:Application Popup
Event Category:None
Event ID:26
Date:9/24/2004
Time:11:23:47 AM
User:N/A
Computer:UHDSSAPPSERV
Description:
Application popup: Windows - Virtual Memory Minimum Too
Low : Your system is low on virtual memory. Windows is
increasing the size of your virtual memory paging file.
During this process, memory requests for some applications
may be denied. For more information, see Help.
The memory ran low first - you can monitor memory on the
server with System Monitor.
In terms of the reboot and dump, you can use the Windows
Debugging tools to analyzer the memory dump file to
determine was caused the server to crash. You can get more
information and download the debugging tools from:
http://www.microsoft.com/whdc/devtoo...g/default.mspx
-Sue
On Tue, 28 Sep 2004 11:09:31 -0700, "Chris"
<anonymous@.discussions.microsoft.com> wrote:

>I have a Windows 2000 SP4 server running SQL Server 2000
>Enterprise Edition that continually gets an event 6008
>(the previous shutdown was unexpected). I also get the
>following bugcheck and memory error. Does anyone know
>what these errors are and how to correct them? Thanks.
>Event Type:Information
>Event Source:Save Dump
>Event Category:None
>Event ID:1001
>Date:9/24/2004
>Time:11:38:37 AM
>User:N/A
>Computer:UHDSSAPPSERV
>Description:
>The computer has rebooted from a bugcheck. The bugcheck
>was: 0x000000d1 (0x8d0ee101, 0x00000002, 0x00000000,
>0x8d0ee101). Microsoft Windows 2000 [v15.2195]. A dump was
>saved in: C:\WINNT\MEMORY.DMP.
>Event Type:Information
>Event Source:Application Popup
>Event Category:None
>Event ID:26
>Date:9/24/2004
>Time:11:23:47 AM
>User:N/A
>Computer:UHDSSAPPSERV
>Description:
>Application popup: Windows - Virtual Memory Minimum Too
>Low : Your system is low on virtual memory. Windows is
>increasing the size of your virtual memory paging file.
>During this process, memory requests for some applications
>may be denied. For more information, see Help.
|||Thanks for the reply. I ran windbg and got the following
message:
BugCheck D1, {1060213, 2, 0, f64d1932}
Probably caused by : SCSIPORT.SYS ( SCSIPORT!
SpAllocateSrbExtension+156 )
After searching Microsoft, there seemed to be many
potential causes for scsiport.sys errors, but could not
find one that exactly matched this criteria.
Followup: MachineOwner
>--Original Message--
>The memory ran low first - you can monitor memory on the
>server with System Monitor.
>In terms of the reboot and dump, you can use the Windows
>Debugging tools to analyzer the memory dump file to
>determine was caused the server to crash. You can get more
>information and download the debugging tools from:
>http://www.microsoft.com/whdc/devtoo...ging/default.m
spx[vbcol=seagreen]
>-Sue
>On Tue, 28 Sep 2004 11:09:31 -0700, "Chris"
><anonymous@.discussions.microsoft.com> wrote:
was[vbcol=seagreen]
applications
>.
>

Event_id 6008 - Unexpected Reboot

I have a Windows 2000 SP4 server running SQL Server 2000
Enterprise Edition that continually gets an event 6008
(the previous shutdown was unexpected). I also get the
following bugcheck and memory error. Does anyone know
what these errors are and how to correct them? Thanks.
Event Type: Information
Event Source: Save Dump
Event Category: None
Event ID: 1001
Date: 9/24/2004
Time: 11:38:37 AM
User: N/A
Computer: UHDSSAPPSERV
Description:
The computer has rebooted from a bugcheck. The bugcheck
was: 0x000000d1 (0x8d0ee101, 0x00000002, 0x00000000,
0x8d0ee101). Microsoft Windows 2000 [v15.2195]. A dump was
saved in: C:\WINNT\MEMORY.DMP.
Event Type: Information
Event Source: Application Popup
Event Category: None
Event ID: 26
Date: 9/24/2004
Time: 11:23:47 AM
User: N/A
Computer: UHDSSAPPSERV
Description:
Application popup: Windows - Virtual Memory Minimum Too
Low : Your system is low on virtual memory. Windows is
increasing the size of your virtual memory paging file.
During this process, memory requests for some applications
may be denied. For more information, see Help.The memory ran low first - you can monitor memory on the
server with System Monitor.
In terms of the reboot and dump, you can use the Windows
Debugging tools to analyzer the memory dump file to
determine was caused the server to crash. You can get more
information and download the debugging tools from:
http://www.microsoft.com/whdc/devtools/debugging/default.mspx
-Sue
On Tue, 28 Sep 2004 11:09:31 -0700, "Chris"
<anonymous@.discussions.microsoft.com> wrote:
>I have a Windows 2000 SP4 server running SQL Server 2000
>Enterprise Edition that continually gets an event 6008
>(the previous shutdown was unexpected). I also get the
>following bugcheck and memory error. Does anyone know
>what these errors are and how to correct them? Thanks.
>Event Type: Information
>Event Source: Save Dump
>Event Category: None
>Event ID: 1001
>Date: 9/24/2004
>Time: 11:38:37 AM
>User: N/A
>Computer: UHDSSAPPSERV
>Description:
>The computer has rebooted from a bugcheck. The bugcheck
>was: 0x000000d1 (0x8d0ee101, 0x00000002, 0x00000000,
>0x8d0ee101). Microsoft Windows 2000 [v15.2195]. A dump was
>saved in: C:\WINNT\MEMORY.DMP.
>Event Type: Information
>Event Source: Application Popup
>Event Category: None
>Event ID: 26
>Date: 9/24/2004
>Time: 11:23:47 AM
>User: N/A
>Computer: UHDSSAPPSERV
>Description:
>Application popup: Windows - Virtual Memory Minimum Too
>Low : Your system is low on virtual memory. Windows is
>increasing the size of your virtual memory paging file.
>During this process, memory requests for some applications
>may be denied. For more information, see Help.|||Thanks for the reply. I ran windbg and got the following
message:
BugCheck D1, {1060213, 2, 0, f64d1932}
Probably caused by : SCSIPORT.SYS ( SCSIPORT!
SpAllocateSrbExtension+156 )
After searching Microsoft, there seemed to be many
potential causes for scsiport.sys errors, but could not
find one that exactly matched this criteria.
Followup: MachineOwner
>--Original Message--
>The memory ran low first - you can monitor memory on the
>server with System Monitor.
>In terms of the reboot and dump, you can use the Windows
>Debugging tools to analyzer the memory dump file to
>determine was caused the server to crash. You can get more
>information and download the debugging tools from:
>http://www.microsoft.com/whdc/devtools/debugging/default.m
spx
>-Sue
>On Tue, 28 Sep 2004 11:09:31 -0700, "Chris"
><anonymous@.discussions.microsoft.com> wrote:
>>I have a Windows 2000 SP4 server running SQL Server 2000
>>Enterprise Edition that continually gets an event 6008
>>(the previous shutdown was unexpected). I also get the
>>following bugcheck and memory error. Does anyone know
>>what these errors are and how to correct them? Thanks.
>>Event Type: Information
>>Event Source: Save Dump
>>Event Category: None
>>Event ID: 1001
>>Date: 9/24/2004
>>Time: 11:38:37 AM
>>User: N/A
>>Computer: UHDSSAPPSERV
>>Description:
>>The computer has rebooted from a bugcheck. The bugcheck
>>was: 0x000000d1 (0x8d0ee101, 0x00000002, 0x00000000,
>>0x8d0ee101). Microsoft Windows 2000 [v15.2195]. A dump
was
>>saved in: C:\WINNT\MEMORY.DMP.
>>Event Type: Information
>>Event Source: Application Popup
>>Event Category: None
>>Event ID: 26
>>Date: 9/24/2004
>>Time: 11:23:47 AM
>>User: N/A
>>Computer: UHDSSAPPSERV
>>Description:
>>Application popup: Windows - Virtual Memory Minimum Too
>>Low : Your system is low on virtual memory. Windows is
>>increasing the size of your virtual memory paging file.
>>During this process, memory requests for some
applications
>>may be denied. For more information, see Help.
>.
>

event viwer

Is there a way to pull the event viwer from a system sp or
xp with out writing a new xp?Jared,
"pull" means? you can use master..xp_logevent or RAISERROR (...) WITH LOG to
log a user-defined message to the Event Viewer. Does that help?
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Jared Kirkpatrick" <jared@.hgpdev.com> wrote in message
news:83da01c35abd$5cc29280$a001280a@.phx.gbl...
> Is there a way to pull the event viwer from a system sp or
> xp with out writing a new xp?|||That works if I need to log an event, but I need to read
the events.
>--Original Message--
>Jared,
>"pull" means? you can use master..xp_logevent or
RAISERROR (...) WITH LOG to
>log a user-defined message to the Event Viewer. Does that
help?
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jared Kirkpatrick" <jared@.hgpdev.com> wrote in message
>news:83da01c35abd$5cc29280$a001280a@.phx.gbl...
>> Is there a way to pull the event viwer from a system sp
or
>> xp with out writing a new xp?
>
>.
>

Event Viewer won't display events

I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
Do or die..
Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Event Viewer won't display events

I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Event Viewer won't display events

I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Event Viewer Overload

With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
every 12 seconds in the security log on each server registered and connected.
This is despite audit being set to failure only. This makes the logs
virtually unusable for analysis purposes. We do not have this problem with
the same EM client on NT4 sp6. Can anyone advise if it is possible to stop
this constant logging?
Try turning off the polling of the services that is turned
on by default in Enterprise Manager.
In Enterprise Manager, go to the menu to Tools, select
Options. On the General Tab, remove the check for Server
State Polling.
-Sue
On Wed, 30 Mar 2005 08:31:05 -0800, "kedda"
<kedda@.discussions.microsoft.com> wrote:

>With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
>every 12 seconds in the security log on each server registered and connected.
> This is despite audit being set to failure only. This makes the logs
>virtually unusable for analysis purposes. We do not have this problem with
>the same EM client on NT4 sp6. Can anyone advise if it is possible to stop
>this constant logging?

Event Viewer Overload

With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
every 12 seconds in the security log on each server registered and connected.
This is despite audit being set to failure only. This makes the logs
virtually unusable for analysis purposes. We do not have this problem with
the same EM client on NT4 sp6. Can anyone advise if it is possible to stop
this constant logging?Try turning off the polling of the services that is turned
on by default in Enterprise Manager.
In Enterprise Manager, go to the menu to Tools, select
Options. On the General Tab, remove the check for Server
State Polling.
-Sue
On Wed, 30 Mar 2005 08:31:05 -0800, "kedda"
<kedda@.discussions.microsoft.com> wrote:
>With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
>every 12 seconds in the security log on each server registered and connected.
> This is despite audit being set to failure only. This makes the logs
>virtually unusable for analysis purposes. We do not have this problem with
>the same EM client on NT4 sp6. Can anyone advise if it is possible to stop
>this constant logging?

Event Viewer Overload

With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
every 12 seconds in the security log on each server registered and connected
.
This is despite audit being set to failure only. This makes the logs
virtually unusable for analysis purposes. We do not have this problem with
the same EM client on NT4 sp6. Can anyone advise if it is possible to stop
this constant logging?Try turning off the polling of the services that is turned
on by default in Enterprise Manager.
In Enterprise Manager, go to the menu to Tools, select
Options. On the General Tab, remove the check for Server
State Polling.
-Sue
On Wed, 30 Mar 2005 08:31:05 -0800, "kedda"
<kedda@.discussions.microsoft.com> wrote:

>With a SQL2000 EM installed on an XP pro client, we are getting 2 entries
>every 12 seconds in the security log on each server registered and connecte
d.
> This is despite audit being set to failure only. This makes the logs
>virtually unusable for analysis purposes. We do not have this problem wit
h
>the same EM client on NT4 sp6. Can anyone advise if it is possible to sto
p
>this constant logging?

event viewer msg thrown for ms sql

Hi guys

i am puzzled on how to decipher the below msg on my sql server
Had tried adjusting the settings but apparantly doesnt work

is this due to my license or what other reasons?

Error msg:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 30 queries and performance may be adversely affected.


sql server : MS SQL Enterprise 8.0any help from anyone?

Event Viewer

Hi All,
All My SQL SERVER whether it is successfull or Fail it is written in Windows
Event Viewer is there any way it can stop that .I mean this information is
written into sql server log so i don't want this to be written in Event
Viewer?
I would appericate if anyone can help me with this
Jitesh k
In Enterprise Manager you can select the properties of the Job and Select the
Notifications tab. The Write to Windows application Event Log check box
determines whether the Event Log Job Notification is enabled or not.
The Event Log Job Notification can also be disabled using the sp_update_job
Stored Procedure as illustrated below:
eg.
EXEC msdb.dbo.sp_update_job @.job_name = 'foo',
@.notify_level_eventlog = 0
- Peter Ward
WARDY IT Solutions
"Jiteshk" wrote:

> Hi All,
> All My SQL SERVER whether it is successfull or Fail it is written in Windows
> Event Viewer is there any way it can stop that .I mean this information is
> written into sql server log so i don't want this to be written in Event
> Viewer?
> I would appericate if anyone can help me with this
>
>
> --
> Jitesh k
>