I want to monitor the number of times that tempdb was accessed, wether it
grew or shrunk. What counters of perfmon can I use for this? Or should I use
the profiler instead ? There are db file related parameters over there.
Cheers
SQLCatZ
IN the database section of Perfmon there are shrink and growth counters, as
well as file size... I'd go there...
You could also take some code out of sp_spaceused and do your own thing for
size..
As to access, you could use physical reads/writes if the files are on their
own hard drive... otherwise it would be a profiler thing..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> I want to monitor the number of times that tempdb was accessed, wether it
> grew or shrunk. What counters of perfmon can I use for this? Or should I
use
> the profiler instead ? There are db file related parameters over there.
> Cheers
> SQLCatZ
>
|||to add on Wayne's comment, you could use profiler to monitor events of
SP:starting, T-SQL:StmtStarting and RPC:SPStarting, filtering on database id
= 2.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhzwXRlSFHA.1384@.TK2MSFTNGP09.phx.gbl...
> IN the database section of Perfmon there are shrink and growth counters,
> as
> well as file size... I'd go there...
> You could also take some code out of sp_spaceused and do your own thing
> for
> size..
> As to access, you could use physical reads/writes if the files are on
> their
> own hard drive... otherwise it would be a profiler thing..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
> news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> use
>
Showing posts with label counters. Show all posts
Showing posts with label counters. Show all posts
Wednesday, March 21, 2012
Monitoring tempdb usage.
I want to monitor the number of times that tempdb was accessed, wether it
grew or shrunk. What counters of perfmon can I use for this? Or should I use
the profiler instead ? There are db file related parameters over there.
Cheers
SQLCatZIN the database section of Perfmon there are shrink and growth counters, as
well as file size... I'd go there...
You could also take some code out of sp_spaceused and do your own thing for
size..
As to access, you could use physical reads/writes if the files are on their
own hard drive... otherwise it would be a profiler thing..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> I want to monitor the number of times that tempdb was accessed, wether it
> grew or shrunk. What counters of perfmon can I use for this? Or should I
use
> the profiler instead ? There are db file related parameters over there.
> Cheers
> SQLCatZ
>|||to add on Wayne's comment, you could use profiler to monitor events of
SP:starting, T-SQL:StmtStarting and RPC:SPStarting, filtering on database id
= 2.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhzwXRlSFHA.1384@.TK2MSFTNGP09.phx.gbl...
> IN the database section of Perfmon there are shrink and growth counters,
> as
> well as file size... I'd go there...
> You could also take some code out of sp_spaceused and do your own thing
> for
> size..
> As to access, you could use physical reads/writes if the files are on
> their
> own hard drive... otherwise it would be a profiler thing..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
> news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
>> I want to monitor the number of times that tempdb was accessed, wether it
>> grew or shrunk. What counters of perfmon can I use for this? Or should I
> use
>> the profiler instead ? There are db file related parameters over there.
>> Cheers
>> SQLCatZ
>
grew or shrunk. What counters of perfmon can I use for this? Or should I use
the profiler instead ? There are db file related parameters over there.
Cheers
SQLCatZIN the database section of Perfmon there are shrink and growth counters, as
well as file size... I'd go there...
You could also take some code out of sp_spaceused and do your own thing for
size..
As to access, you could use physical reads/writes if the files are on their
own hard drive... otherwise it would be a profiler thing..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> I want to monitor the number of times that tempdb was accessed, wether it
> grew or shrunk. What counters of perfmon can I use for this? Or should I
use
> the profiler instead ? There are db file related parameters over there.
> Cheers
> SQLCatZ
>|||to add on Wayne's comment, you could use profiler to monitor events of
SP:starting, T-SQL:StmtStarting and RPC:SPStarting, filtering on database id
= 2.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhzwXRlSFHA.1384@.TK2MSFTNGP09.phx.gbl...
> IN the database section of Perfmon there are shrink and growth counters,
> as
> well as file size... I'd go there...
> You could also take some code out of sp_spaceused and do your own thing
> for
> size..
> As to access, you could use physical reads/writes if the files are on
> their
> own hard drive... otherwise it would be a profiler thing..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
> news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
>> I want to monitor the number of times that tempdb was accessed, wether it
>> grew or shrunk. What counters of perfmon can I use for this? Or should I
> use
>> the profiler instead ? There are db file related parameters over there.
>> Cheers
>> SQLCatZ
>
Monitoring tempdb usage.
I want to monitor the number of times that tempdb was accessed, wether it
grew or shrunk. What counters of perfmon can I use for this? Or should I use
the profiler instead ? There are db file related parameters over there.
Cheers
SQLCatZIN the database section of Perfmon there are shrink and growth counters, as
well as file size... I'd go there...
You could also take some code out of sp_spaceused and do your own thing for
size..
As to access, you could use physical reads/writes if the files are on their
own hard drive... otherwise it would be a profiler thing..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> I want to monitor the number of times that tempdb was accessed, wether it
> grew or shrunk. What counters of perfmon can I use for this? Or should I
use
> the profiler instead ? There are db file related parameters over there.
> Cheers
> SQLCatZ
>|||to add on Wayne's comment, you could use profiler to monitor events of
SP:starting, T-SQL:StmtStarting and RPC:SPStarting, filtering on database id
= 2.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhzwXRlSFHA.1384@.TK2MSFTNGP09.phx.gbl...
> IN the database section of Perfmon there are shrink and growth counters,
> as
> well as file size... I'd go there...
> You could also take some code out of sp_spaceused and do your own thing
> for
> size..
> As to access, you could use physical reads/writes if the files are on
> their
> own hard drive... otherwise it would be a profiler thing..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
> news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> use
>sql
grew or shrunk. What counters of perfmon can I use for this? Or should I use
the profiler instead ? There are db file related parameters over there.
Cheers
SQLCatZIN the database section of Perfmon there are shrink and growth counters, as
well as file size... I'd go there...
You could also take some code out of sp_spaceused and do your own thing for
size..
As to access, you could use physical reads/writes if the files are on their
own hard drive... otherwise it would be a profiler thing..
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> I want to monitor the number of times that tempdb was accessed, wether it
> grew or shrunk. What counters of perfmon can I use for this? Or should I
use
> the profiler instead ? There are db file related parameters over there.
> Cheers
> SQLCatZ
>|||to add on Wayne's comment, you could use profiler to monitor events of
SP:starting, T-SQL:StmtStarting and RPC:SPStarting, filtering on database id
= 2.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhzwXRlSFHA.1384@.TK2MSFTNGP09.phx.gbl...
> IN the database section of Perfmon there are shrink and growth counters,
> as
> well as file size... I'd go there...
> You could also take some code out of sp_spaceused and do your own thing
> for
> size..
> As to access, you could use physical reads/writes if the files are on
> their
> own hard drive... otherwise it would be a profiler thing..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
> news:B6C93E0A-FC79-4627-ABF8-4A44AA5218DE@.microsoft.com...
> use
>sql
Monday, March 19, 2012
Monitoring SQL Compact Edition Performance
Does SQL Compact Edition expose performance counters to tools like Perfmon as SQL Server does? For instance, can you view lock wait times, cache hit ratio, etc.?
Currently, SQL Compact does not expose any performance counters. It is a in-process database engine, not a service/server process like SQL Server. You can analyze query execution with the query analyzer in SQL Server Management Studio (Express SP2).Monitoring Server Memory.
Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters?
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***
Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters?
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters?
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***
Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters?
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***
Monitoring Server Memory.
Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***
want to use de counters has administrative privileges on the server but
not in sql server, so he couldnt use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.codecomments.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldnt use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Thanks for your answere. I forgot to tell you that the
builtin\administrator is not a member of the sysadmin role on this
server.
*** Sent via Developersdex http://www.codecomments.com ***
Monitoring Server Memory.
Hi, we need to monitor the memory used for sql server. The person who
want to use de counters has administrative privileges on the server but
not in sql server, so he couldn´t use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.developersdex.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldn´t use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
want to use de counters has administrative privileges on the server but
not in sql server, so he couldn´t use the sql server counters in
Performance Monitor Tool.
I am member of the sysadmin server role in sql server and I can use the
counters, So, Do somebody know if the user can have some privileges
differente to sysadmin on sql server to use the counters'
Thanks a lot for your help!
*** Sent via Developersdex http://www.developersdex.com ***Hi,
User with Admin rights on the Server (operating system) should be able to
see all the counters.
FYI, OS Administrators by default will the member of BUILD\ADMIN user in sql
server. BUILD\ADMIN is the part of sysadmin role
Thanks
Hari
SQL Server MVP
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:Oj6VaHHQFHA.4020@.tk2msftngp13.phx.gbl...
> Hi, we need to monitor the memory used for sql server. The person who
> want to use de counters has administrative privileges on the server but
> not in sql server, so he couldn´t use the sql server counters in
> Performance Monitor Tool.
> I am member of the sysadmin server role in sql server and I can use the
> counters, So, Do somebody know if the user can have some privileges
> differente to sysadmin on sql server to use the counters'
> Thanks a lot for your help!
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
Wednesday, March 7, 2012
Monitor network traffic per database
Is it possible to monitor incoming and outgoing network
traffic on a database level? I could only find counters
on server level.
Thanks in advance.
HolgerNot from any network monitor... about the best you can do is to use
profiler. You can see selects, etc and the number of rows returned...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger|||Yes. All the performance counters are at a SQL Server level. Not at a
database specific level. The only thing that comes to my mind is wrt to the
IO operations that can be monitored if you can group filegroups of a
specific database into a single disk and monitor the Disk IO of the specific
disk. This is the max. I've seen implemented. But other parameters are can
be monitored using the profiler as Wayne said ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger
traffic on a database level? I could only find counters
on server level.
Thanks in advance.
HolgerNot from any network monitor... about the best you can do is to use
profiler. You can see selects, etc and the number of rows returned...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger|||Yes. All the performance counters are at a SQL Server level. Not at a
database specific level. The only thing that comes to my mind is wrt to the
IO operations that can be monitored if you can group filegroups of a
specific database into a single disk and monitor the Disk IO of the specific
disk. This is the max. I've seen implemented. But other parameters are can
be monitored using the profiler as Wayne said ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other )
Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>
|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.co...g_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping and what are diffrent counters (performance and other )
Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>
|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.co...g_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other )Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> > we are using sql server 2000 Log Shipping .Pl help me , tell me about how
> to
> > monitor Log Shipping and what are diffrent counters (performance and
> other )
> >
> >
>
>
monitor Log Shipping and what are diffrent counters (performance and other )Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> > we are using sql server 2000 Log Shipping .Pl help me , tell me about how
> to
> > monitor Log Shipping and what are diffrent counters (performance and
> other )
> >
> >
>
>
monitor Log Shipping
we are using sql server 2000 Log Shipping .Pl help me , tell me about how to
monitor Log Shipping and what are diffrent counters (performance and other
)Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.c...og_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
monitor Log Shipping and what are diffrent counters (performance and other
)Ritesh,
The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
to use the built-in Log Shipping Monitor. There are no perfmon counters as
such for log shipping. But you can also monitor the SQL Agent jobs that do
the work.
Hope this helps,
Ron
--
Ron Talmage
SQL Server MVP
"Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> we are using sql server 2000 Log Shipping .Pl help me , tell me about how
to
> monitor Log Shipping and what are diffrent counters (performance and
other )
>|||Hi Ritesh -
Please visit the link and let me know if it's helpful for you.
http://www.sql-server-performance.c...og_shipping.asp
Regards,
Surajit
"Ron Talmage" wrote:
> Ritesh,
> The best way to monitor SQL Server 2000 Enterprise Edition log shipping is
> to use the built-in Log Shipping Monitor. There are no perfmon counters as
> such for log shipping. But you can also monitor the SQL Agent jobs that do
> the work.
> Hope this helps,
> Ron
> --
> Ron Talmage
> SQL Server MVP
> "Ritesh Gupta" <RiteshGupta@.discussions.microsoft.com> wrote in message
> news:51A9CEB5-E966-4020-8FCC-9DEBF7781737@.microsoft.com...
> to
> other )
>
>
Saturday, February 25, 2012
Monitor for 60% server utilization...
I want to monitor a SQL server to alert me when the
server is at 60% utilization. Ideally I want to know
which counters to look for, such as total memory, %
Processor Time, Available memory, anything you can think
of that is relevant. I know sql performance jumps but
maybe over a 15 or 30 second interval, average the
counters and if they average over 60% to send out an
alert.
Question one: Which Perfmon counters would you watch for
to determine what percentage utilized the server is
running at.
Question two: Can you think of an easier way to find
server utilization. Where I can say, "Check this, if its
at this level your server is at 60% utilized."
Question three: Can you tell perfmon to monitor counters
and average them over 30 second intervals and send alerts
when any consecutive 30 seconds maintains 60% utilized.
Are you looking to identify a problem? 60% of what? Disk? Memory? CPU? ?
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:326e01c47e89$58f00200$a401280a@.phx.gbl...
>I want to monitor a SQL server to alert me when the
> server is at 60% utilization. Ideally I want to know
> which counters to look for, such as total memory, %
> Processor Time, Available memory, anything you can think
> of that is relevant. I know sql performance jumps but
> maybe over a 15 or 30 second interval, average the
> counters and if they average over 60% to send out an
> alert.
> Question one: Which Perfmon counters would you watch for
> to determine what percentage utilized the server is
> running at.
> Question two: Can you think of an easier way to find
> server utilization. Where I can say, "Check this, if its
> at this level your server is at 60% utilized."
> Question three: Can you tell perfmon to monitor counters
> and average them over 30 second intervals and send alerts
> when any consecutive 30 seconds maintains 60% utilized.
|||Memory and CPU. Just trying to figure out when the
server is going to needs some help, Either more memory or
another SQL Server.
>--Original Message--
>Are you looking to identify a problem? 60% of what?
Disk? Memory? CPU? ?
>
>"Tim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:326e01c47e89$58f00200$a401280a@.phx.gbl...
think[vbcol=seagreen]
for[vbcol=seagreen]
its[vbcol=seagreen]
counters[vbcol=seagreen]
alerts[vbcol=seagreen]
utilized.
>
>.
>
|||anonymous@.discussions.microsoft.com wrote:
> Memory and CPU. Just trying to figure out when the
> server is going to needs some help, Either more memory or
> another SQL Server.
Or more tuning...
David G.
|||Hi,
1] I often use the following counters to get an initial overview of CPU
and memory :
For CPU :
Processor.%ProcessorTime, and Process.%ProcessorTime[SQLServr]. This
tells me how busy the server is, and whether it is being used by SQL Server.
System.ProcessorQueueLength. Should not be more than 2 per processor.
For Memory :
Memory.PageFaults/s. This should be low, otherwise your system is
constantly going to disk for memory
SQLServer:BufferManager.BufferCacheHitRatio. This should be high,
meaning SQL is finding all its data in memory.
Total Memory and Available memory are not that meaningfull, as SQL
doesnt release memory until another application needs it.
2] There are some really good tools out there that monitor these
counters, and raise alerts when thresholds are reached. I've used Quest
Spotlight, and BMC's DBXray.
3] Some of the perfmon counters are averaged over your sample interval,
others are a 'snapshot' at the time the sample is taken. I dont think
this is configurable.
If you want to be alerted when a threshold value is exceeded, you can
configure perfmon "alerts" to alert you.
thanks
Ian
iank@.iworks.co.za
Tim wrote:
> I want to monitor a SQL server to alert me when the
> server is at 60% utilization. Ideally I want to know
> which counters to look for, such as total memory, %
> Processor Time, Available memory, anything you can think
> of that is relevant. I know sql performance jumps but
> maybe over a 15 or 30 second interval, average the
> counters and if they average over 60% to send out an
> alert.
> Question one: Which Perfmon counters would you watch for
> to determine what percentage utilized the server is
> running at.
> Question two: Can you think of an easier way to find
> server utilization. Where I can say, "Check this, if its
> at this level your server is at 60% utilized."
> Question three: Can you tell perfmon to monitor counters
> and average them over 30 second intervals and send alerts
> when any consecutive 30 seconds maintains 60% utilized.
server is at 60% utilization. Ideally I want to know
which counters to look for, such as total memory, %
Processor Time, Available memory, anything you can think
of that is relevant. I know sql performance jumps but
maybe over a 15 or 30 second interval, average the
counters and if they average over 60% to send out an
alert.
Question one: Which Perfmon counters would you watch for
to determine what percentage utilized the server is
running at.
Question two: Can you think of an easier way to find
server utilization. Where I can say, "Check this, if its
at this level your server is at 60% utilized."
Question three: Can you tell perfmon to monitor counters
and average them over 30 second intervals and send alerts
when any consecutive 30 seconds maintains 60% utilized.
Are you looking to identify a problem? 60% of what? Disk? Memory? CPU? ?
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:326e01c47e89$58f00200$a401280a@.phx.gbl...
>I want to monitor a SQL server to alert me when the
> server is at 60% utilization. Ideally I want to know
> which counters to look for, such as total memory, %
> Processor Time, Available memory, anything you can think
> of that is relevant. I know sql performance jumps but
> maybe over a 15 or 30 second interval, average the
> counters and if they average over 60% to send out an
> alert.
> Question one: Which Perfmon counters would you watch for
> to determine what percentage utilized the server is
> running at.
> Question two: Can you think of an easier way to find
> server utilization. Where I can say, "Check this, if its
> at this level your server is at 60% utilized."
> Question three: Can you tell perfmon to monitor counters
> and average them over 30 second intervals and send alerts
> when any consecutive 30 seconds maintains 60% utilized.
|||Memory and CPU. Just trying to figure out when the
server is going to needs some help, Either more memory or
another SQL Server.
>--Original Message--
>Are you looking to identify a problem? 60% of what?
Disk? Memory? CPU? ?
>
>"Tim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:326e01c47e89$58f00200$a401280a@.phx.gbl...
think[vbcol=seagreen]
for[vbcol=seagreen]
its[vbcol=seagreen]
counters[vbcol=seagreen]
alerts[vbcol=seagreen]
utilized.
>
>.
>
|||anonymous@.discussions.microsoft.com wrote:
> Memory and CPU. Just trying to figure out when the
> server is going to needs some help, Either more memory or
> another SQL Server.
Or more tuning...
David G.
|||Hi,
1] I often use the following counters to get an initial overview of CPU
and memory :
For CPU :
Processor.%ProcessorTime, and Process.%ProcessorTime[SQLServr]. This
tells me how busy the server is, and whether it is being used by SQL Server.
System.ProcessorQueueLength. Should not be more than 2 per processor.
For Memory :
Memory.PageFaults/s. This should be low, otherwise your system is
constantly going to disk for memory
SQLServer:BufferManager.BufferCacheHitRatio. This should be high,
meaning SQL is finding all its data in memory.
Total Memory and Available memory are not that meaningfull, as SQL
doesnt release memory until another application needs it.
2] There are some really good tools out there that monitor these
counters, and raise alerts when thresholds are reached. I've used Quest
Spotlight, and BMC's DBXray.
3] Some of the perfmon counters are averaged over your sample interval,
others are a 'snapshot' at the time the sample is taken. I dont think
this is configurable.
If you want to be alerted when a threshold value is exceeded, you can
configure perfmon "alerts" to alert you.
thanks
Ian
iank@.iworks.co.za
Tim wrote:
> I want to monitor a SQL server to alert me when the
> server is at 60% utilization. Ideally I want to know
> which counters to look for, such as total memory, %
> Processor Time, Available memory, anything you can think
> of that is relevant. I know sql performance jumps but
> maybe over a 15 or 30 second interval, average the
> counters and if they average over 60% to send out an
> alert.
> Question one: Which Perfmon counters would you watch for
> to determine what percentage utilized the server is
> running at.
> Question two: Can you think of an easier way to find
> server utilization. Where I can say, "Check this, if its
> at this level your server is at 60% utilized."
> Question three: Can you tell perfmon to monitor counters
> and average them over 30 second intervals and send alerts
> when any consecutive 30 seconds maintains 60% utilized.
Subscribe to:
Posts (Atom)