Showing posts with label errorlog. Show all posts
Showing posts with label errorlog. Show all posts

Wednesday, March 21, 2012

Menssage continuos en errorlog

2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
Connection: Non-Trusted.
2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: Trusted.
Hello: That I can do constantly with this message that me aparace in the
Errorlog, this growing much the file of Errorlog. Thanks.
In Enterprise Manager, check the SQL Server Properties Security Tab whether
login auditing is turned on.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
> 2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
> Connection: Non-Trusted.
> 2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
> AUTHORITY\SYSTEM'. Connection: Trusted.
>
> Hello: That I can do constantly with this message that me aparace in the
> Errorlog, this growing much the file of Errorlog. Thanks.
>
|||Thank you very much by your aid. but I must Reinitiate the operating system
so that it takes the changed value? or to terminate and only to raise the
services of SQL. Thanks again.
Joel Morales
"Dejan Sarka" wrote:

> In Enterprise Manager, check the SQL Server Properties Security Tab whether
> login auditing is turned on.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
> news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
>
>
|||> Thank you very much by your aid. but I must Reinitiate the operating
system
> so that it takes the changed value? or to terminate and only to raise the
> services of SQL. Thanks again.
Restarting SQL Server after change should be enough.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Menssage continuos en errorlog

2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
Connection: Non-Trusted.
2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: Trusted.
Hello: That I can do constantly with this message that me aparace in the
Errorlog, this growing much the file of Errorlog. Thanks.In Enterprise Manager, check the SQL Server Properties Security Tab whether
login auditing is turned on.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
> 2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
> Connection: Non-Trusted.
> 2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
> AUTHORITY\SYSTEM'. Connection: Trusted.
>
> Hello: That I can do constantly with this message that me aparace in the
> Errorlog, this growing much the file of Errorlog. Thanks.
>|||Thank you very much by your aid. but I must Reinitiate the operating system
so that it takes the changed value? or to terminate and only to raise the
services of SQL. Thanks again.
Joel Morales
"Dejan Sarka" wrote:

> In Enterprise Manager, check the SQL Server Properties Security Tab whethe
r
> login auditing is turned on.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
> news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
>
>|||> Thank you very much by your aid. but I must Reinitiate the operating
system
> so that it takes the changed value? or to terminate and only to raise the
> services of SQL. Thanks again.
Restarting SQL Server after change should be enough.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.comsql

Menssage continuos en errorlog

2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
Connection: Non-Trusted.
2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: Trusted.
Hello: That I can do constantly with this message that me aparace in the
Errorlog, this growing much the file of Errorlog. Thanks.In Enterprise Manager, check the SQL Server Properties Security Tab whether
login auditing is turned on.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
> 2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
> Connection: Non-Trusted.
> 2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
> AUTHORITY\SYSTEM'. Connection: Trusted.
>
> Hello: That I can do constantly with this message that me aparace in the
> Errorlog, this growing much the file of Errorlog. Thanks.
>|||Thank you very much by your aid. but I must Reinitiate the operating system
so that it takes the changed value? or to terminate and only to raise the
services of SQL. Thanks again.
Joel Morales
"Dejan Sarka" wrote:
> In Enterprise Manager, check the SQL Server Properties Security Tab whether
> login auditing is turned on.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
> "Joel Morales" <Joel Morales@.discussions.microsoft.com> wrote in message
> news:EB448C02-D3B5-4D87-89FB-081A8F453E7C@.microsoft.com...
> > 2004-10-14 16:12:57.92 logon Login succeeded for user 'sistemas'.
> > Connection: Non-Trusted.
> > 2004-10-14 16:12:58.57 logon Login succeeded for user 'NT
> > AUTHORITY\SYSTEM'. Connection: Trusted.
> >
> >
> > Hello: That I can do constantly with this message that me aparace in the
> > Errorlog, this growing much the file of Errorlog. Thanks.
> >
>
>|||> Thank you very much by your aid. but I must Reinitiate the operating
system
> so that it takes the changed value? or to terminate and only to raise the
> services of SQL. Thanks again.
Restarting SQL Server after change should be enough.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Friday, February 24, 2012

Memory paging out noted in errorlog

As my SQL Server starts, in the SQL error log, there is a message as
follows:
A significant part of sql server process memory has been paged out. This may
result in a performance degradation. Duration: 0 seconds. Working set (KB):
37376, committed (KB): 105592, memory utilization: 35%.
Do I have to be concerned ? I have 64 bit and 16GB of RAM
What is min/max server memory settings? Are there other processes running
on the server that are eating up memory? Paging in general is horrible for
performance.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Hassan" <hassan@.test.com> wrote in message
news:OtgJd4CJIHA.3672@.TK2MSFTNGP02.phx.gbl...
> As my SQL Server starts, in the SQL error log, there is a message as
> follows:
> A significant part of sql server process memory has been paged out. This
> may result in a performance degradation. Duration: 0 seconds. Working set
> (KB): 37376, committed (KB): 105592, memory utilization: 35%.
> Do I have to be concerned ? I have 64 bit and 16GB of RAM
>

Memory paging out noted in errorlog

As my SQL Server starts, in the SQL error log, there is a message as
follows:
A significant part of sql server process memory has been paged out. This may
result in a performance degradation. Duration: 0 seconds. Working set (KB):
37376, committed (KB): 105592, memory utilization: 35%.
Do I have to be concerned ? I have 64 bit and 16GB of RAMWhat is min/max server memory settings? Are there other processes running
on the server that are eating up memory? Paging in general is horrible for
performance.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Hassan" <hassan@.test.com> wrote in message
news:OtgJd4CJIHA.3672@.TK2MSFTNGP02.phx.gbl...
> As my SQL Server starts, in the SQL error log, there is a message as
> follows:
> A significant part of sql server process memory has been paged out. This
> may result in a performance degradation. Duration: 0 seconds. Working set
> (KB): 37376, committed (KB): 105592, memory utilization: 35%.
> Do I have to be concerned ? I have 64 bit and 16GB of RAM
>

Memory paging out noted in errorlog

As my SQL Server starts, in the SQL error log, there is a message as
follows:
A significant part of sql server process memory has been paged out. This may
result in a performance degradation. Duration: 0 seconds. Working set (KB):
37376, committed (KB): 105592, memory utilization: 35%.
Do I have to be concerned ? I have 64 bit and 16GB of RAMWhat is min/max server memory settings? Are there other processes running
on the server that are eating up memory? Paging in general is horrible for
performance.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Hassan" <hassan@.test.com> wrote in message
news:OtgJd4CJIHA.3672@.TK2MSFTNGP02.phx.gbl...
> As my SQL Server starts, in the SQL error log, there is a message as
> follows:
> A significant part of sql server process memory has been paged out. This
> may result in a performance degradation. Duration: 0 seconds. Working set
> (KB): 37376, committed (KB): 105592, memory utilization: 35%.
> Do I have to be concerned ? I have 64 bit and 16GB of RAM
>