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
Showing posts with label errorlog. Show all posts
Showing posts with label errorlog. Show all posts
Wednesday, March 21, 2012
Menssage continuos en errorlog
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
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
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
>
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
>
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
>
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
>
Subscribe to:
Posts (Atom)