Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
Thanks
Hi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks
|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Showing posts with label errors. Show all posts
Showing posts with label errors. Show all posts
Monday, March 19, 2012
Access Violation occurred writing address
Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Access Violation occurred writing address
Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Sunday, March 11, 2012
Access to SQL Server System Logs
I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?Hi,
no this is the most common way to do this.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)