Performance counter quest

Hi,
SQL2000 Standard sp3.
Windows 2000 server, 2 physical processors, Intel hyper threading tech.
I am running Performance monitor from another machine which is windows 2000 terminal , to monitor the above mentioned sqlserver. The output of the csv file showing total processor time > 300. I dont understand why it is showing instead of values < 100. I
n that machine i can see .NET CLR counters also. Is this behaviour because of .NET?
(PDH-CSV 4.0) (Pacific Daylight Time)(420)\\AB01\Process(_Total)\% Privileged Time\\AB01\Process(_Total)\% Processor Time
4/13/04 5:00 AM349.7912317399.6868476
4/13/04 5:00 AM350399.8958333
4/13/04 5:00 AM399.7918835399.8959417
4/13/04 5:01 AM343.8541667399.6875
How can i take the processor time to calculate cpu usage? Any help appreciated
thanks
kris
Look at the Processor(_Total)\% Processor Time for values that you expect.
Some of the counters are explained at :
http://www.extremeexperts.com/sql/ar...LCounters.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"kris" <anonymous@.discussions.microsoft.com> wrote in message
news:BF219D19-16FC-40DD-8728-31A2E8E2580A@.microsoft.com...
> Hi,
> SQL2000 Standard sp3.
> Windows 2000 server, 2 physical processors, Intel hyper threading tech.
> I am running Performance monitor from another machine which is windows
2000 terminal , to monitor the above mentioned sqlserver. The output of the
csv file showing total processor time > 300. I dont understand why it is
showing instead of values < 100. In that machine i can see .NET CLR
counters also. Is this behaviour because of .NET?
> (PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\%
Privileged Time \\AB01\Process(_Total)\% Processor Time
> 4/13/04 5:00 AM 349.7912317 399.6868476
> 4/13/04 5:00 AM 350 399.8958333
> 4/13/04 5:00 AM 399.7918835 399.8959417
> 4/13/04 5:01 AM 343.8541667 399.6875
> How can i take the processor time to calculate cpu usage? Any help
appreciated
> thanks
> kris
>
>

Performance counter quest

Hi
SQL2000 Standard sp3.
Windows 2000 server, 2 physical processors, Intel hyper threading tech
I am running Performance monitor from another machine which is windows 2000 terminal , to monitor the above mentioned sqlserver. The output of the csv file showing total processor time > 300. I dont understand why it is showing instead of values < 100. In that machine i can see .NET CLR counters also. Is this behaviour because of .NET
(PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\% Privileged Time \\AB01\Process(_Total)\% Processor Tim
4/13/04 5:00 AM 349.7912317 399.686847
4/13/04 5:00 AM 350 399.895833
4/13/04 5:00 AM 399.7918835 399.895941
4/13/04 5:01 AM 343.8541667 399.687
How can i take the processor time to calculate cpu usage? Any help appreciate
thank
kriLook at the Processor(_Total)\% Processor Time for values that you expect.
Some of the counters are explained at :
http://www.extremeexperts.com/sql/articles/SQLCounters.aspx
--
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
"kris" <anonymous@.discussions.microsoft.com> wrote in message
news:BF219D19-16FC-40DD-8728-31A2E8E2580A@.microsoft.com...
> Hi,
> SQL2000 Standard sp3.
> Windows 2000 server, 2 physical processors, Intel hyper threading tech.
> I am running Performance monitor from another machine which is windows
2000 terminal , to monitor the above mentioned sqlserver. The output of the
csv file showing total processor time > 300. I dont understand why it is
showing instead of values < 100. In that machine i can see .NET CLR
counters also. Is this behaviour because of .NET?
> (PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\%
Privileged Time \\AB01\Process(_Total)\% Processor Time
> 4/13/04 5:00 AM 349.7912317 399.6868476
> 4/13/04 5:00 AM 350 399.8958333
> 4/13/04 5:00 AM 399.7918835 399.8959417
> 4/13/04 5:01 AM 343.8541667 399.6875
> How can i take the processor time to calculate cpu usage? Any help
appreciated
> thanks
> kris
>
>

Performance counter quest

Hi,
SQL2000 Standard sp3.
Windows 2000 server, 2 physical processors, Intel hyper threading tech.
I am running Performance monitor from another machine which is Windows 2000
terminal , to monitor the above mentioned sqlserver. The output of the csv f
ile showing total processor time > 300. I dont understand why it is showing
instead of values < 100. I
n that machine i can see .NET CLR counters also. Is this behaviour because o
f .NET?
(PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\% Privileg
ed Time \\AB01\Process(_Total)\% Processor Time
4/13/04 5:00 AM 349.7912317 399.6868476
4/13/04 5:00 AM 350 399.8958333
4/13/04 5:00 AM 399.7918835 399.8959417
4/13/04 5:01 AM 343.8541667 399.6875
How can i take the processor time to calculate cpu usage? Any help appreciat
ed
thanks
krisLook at the Processor(_Total)\% Processor Time for values that you expect.
Some of the counters are explained at :
http://www.extremeexperts.com/sql/a...QLCounters.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"kris" <anonymous@.discussions.microsoft.com> wrote in message
news:BF219D19-16FC-40DD-8728-31A2E8E2580A@.microsoft.com...
> Hi,
> SQL2000 Standard sp3.
> Windows 2000 server, 2 physical processors, Intel hyper threading tech.
> I am running Performance monitor from another machine which is windows
2000 terminal , to monitor the above mentioned sqlserver. The output of the
csv file showing total processor time > 300. I dont understand why it is
showing instead of values < 100. In that machine i can see .NET CLR
counters also. Is this behaviour because of .NET?
> (PDH-CSV 4.0) (Pacific Daylight Time)(420) \\AB01\Process(_Total)\%
Privileged Time \\AB01\Process(_Total)\% Processor Time
> 4/13/04 5:00 AM 349.7912317 399.6868476
> 4/13/04 5:00 AM 350 399.8958333
> 4/13/04 5:00 AM 399.7918835 399.8959417
> 4/13/04 5:01 AM 343.8541667 399.6875
> How can i take the processor time to calculate cpu usage? Any help
appreciated
> thanks
> kris
>
>

Performance baseline report

Hi all,

I want to create a server performance baseline report for my database server. I know I can use System Mointor and SQL Profiler to monitor the server by reading the "SQL Server Books Online". However, there have too many counters, I don't know which counters should I use. If I choose to use the counter, I don't know what is the expect value for the counter.

For example, SQL Server: Buffer Manger Object has almost 22 counters. Which counters should I monitor? If I monitor AWE Lookup Maps/Sec, then what is the expect value for the good performance.

Anyone know a good refer or test book can help me to create a basline report

Thank a lot!

The following articles should help you going:

http://www.sql-server-performance.com/articles/audit/perform_performance_audit_p1.aspx

http://www.sql-server-performance.com/articles/per/10_baselining_tips_p1.aspx

-Sue

|||

Thanks the articles are really helpfull. Do you think the SqL Server Performance Monitoring and Management Tools such as SQL Diagnostic Manager or Spotlight on SQL Server Enterprise are helpful? If I design to buy those tools, do I need to create my own performance baseline report.

|||

The decision on purchasing those types of tools often depends on how many servers, databases you need to monitor per DBA and the nature of the databases, how critical they are to the business. Sometimes a "lightweight" shop can get by just buy rolling their own monitoring systems. But if you can get the money for the purchase, it certainly won't hurt! And some of them can really help a more junior level person get up to speed.

Personally, I liked Diagnostic Manager when I used it. I don't think you would really need to baseline separately if using DM. It has a repository to store the data captured and reporting functionality. It has built in reports and you can also write your own. So you can do trend reporting, analysis from a certain point in time and view changes, variances, etc. I know you can download a demo and try it out. Their support was good, company was helpful when evaluating this product - as well as others.

It's been too many years since I used Spotlight and years ago I didn't care for the performance overhead and all the junk in put in the database. I didn't like it, didn't feel it added much value and didn't like cleaning up from the install when we got rid of it. I know they've changed a lot since so I can't really give a decent opinion.

Not exactly the same thing but somewhat along the same lines and as long as we're on the general subject, have you looked at the Performance Dashboard reports from Microsoft? They are more to provide information at a given point in time in terms of performance. But you can export the reports out to files if needed. They are lightweight and do a good job of assessing performance issues, allowing drill through into various areas. You need to be on SQL 2005 SP2 to use them. No other requirements and they are free. Check the following link for a brief overview and a link to the download: http://blogs.msdn.com/sqltips/archive/2007/03/29/sql-server-2005-performance-dashboard-reports.aspx

-Sue

Performance baseline report

Hi all,

I want to create a server performance baseline report for my database server. I know I can use System Mointor and SQL Profiler to monitor the server by reading the "SQL Server Books Online". However, there have too many counters, I don't know which counters should I use. If I choose to use the counter, I don't know what is the expect value for the counter.

For example, SQL Server: Buffer Manger Object has almost 22 counters. Which counters should I monitor? If I monitor AWE Lookup Maps/Sec, then what is the expect value for the good performance.

Anyone know a good refer or test book can help me to create a basline report

Thank a lot!

The following articles should help you going:

http://www.sql-server-performance.com/articles/audit/perform_performance_audit_p1.aspx

http://www.sql-server-performance.com/articles/per/10_baselining_tips_p1.aspx

-Sue

|||

Thanks the articles are really helpfull. Do you think the SqL Server Performance Monitoring and Management Tools such as SQL Diagnostic Manager or Spotlight on SQL Server Enterprise are helpful? If I design to buy those tools, do I need to create my own performance baseline report.

|||

The decision on purchasing those types of tools often depends on how many servers, databases you need to monitor per DBA and the nature of the databases, how critical they are to the business. Sometimes a "lightweight" shop can get by just buy rolling their own monitoring systems. But if you can get the money for the purchase, it certainly won't hurt! And some of them can really help a more junior level person get up to speed.

Personally, I liked Diagnostic Manager when I used it. I don't think you would really need to baseline separately if using DM. It has a repository to store the data captured and reporting functionality. It has built in reports and you can also write your own. So you can do trend reporting, analysis from a certain point in time and view changes, variances, etc. I know you can download a demo and try it out. Their support was good, company was helpful when evaluating this product - as well as others.

It's been too many years since I used Spotlight and years ago I didn't care for the performance overhead and all the junk in put in the database. I didn't like it, didn't feel it added much value and didn't like cleaning up from the install when we got rid of it. I know they've changed a lot since so I can't really give a decent opinion.

Not exactly the same thing but somewhat along the same lines and as long as we're on the general subject, have you looked at the Performance Dashboard reports from Microsoft? They are more to provide information at a given point in time in terms of performance. But you can export the reports out to files if needed. They are lightweight and do a good job of assessing performance issues, allowing drill through into various areas. You need to be on SQL 2005 SP2 to use them. No other requirements and they are free. Check the following link for a brief overview and a link to the download: http://blogs.msdn.com/sqltips/archive/2007/03/29/sql-server-2005-performance-dashboard-reports.aspx

-Sue

Performance baseline report

Hi all,

I want to create a server performance baseline report for my database server. I know I can use System Mointor and SQL Profiler to monitor the server by reading the "SQL Server Books Online". However, there have too many counters, I don't know which counters should I use. If I choose to use the counter, I don't know what is the expect value for the counter.

For example, SQL Server: Buffer Manger Object has almost 22 counters. Which counters should I monitor? If I monitor AWE Lookup Maps/Sec, then what is the expect value for the good performance.

Anyone know a good refer or test book can help me to create a basline report

Thank a lot!

The following articles should help you going:

http://www.sql-server-performance.com/articles/audit/perform_performance_audit_p1.aspx

http://www.sql-server-performance.com/articles/per/10_baselining_tips_p1.aspx

-Sue

|||

Thanks the articles are really helpfull. Do you think the SqL Server Performance Monitoring and Management Tools such as SQL Diagnostic Manager or Spotlight on SQL Server Enterprise are helpful? If I design to buy those tools, do I need to create my own performance baseline report.

|||

The decision on purchasing those types of tools often depends on how many servers, databases you need to monitor per DBA and the nature of the databases, how critical they are to the business. Sometimes a "lightweight" shop can get by just buy rolling their own monitoring systems. But if you can get the money for the purchase, it certainly won't hurt! And some of them can really help a more junior level person get up to speed.

Personally, I liked Diagnostic Manager when I used it. I don't think you would really need to baseline separately if using DM. It has a repository to store the data captured and reporting functionality. It has built in reports and you can also write your own. So you can do trend reporting, analysis from a certain point in time and view changes, variances, etc. I know you can download a demo and try it out. Their support was good, company was helpful when evaluating this product - as well as others.

It's been too many years since I used Spotlight and years ago I didn't care for the performance overhead and all the junk in put in the database. I didn't like it, didn't feel it added much value and didn't like cleaning up from the install when we got rid of it. I know they've changed a lot since so I can't really give a decent opinion.

Not exactly the same thing but somewhat along the same lines and as long as we're on the general subject, have you looked at the Performance Dashboard reports from Microsoft? They are more to provide information at a given point in time in terms of performance. But you can export the reports out to files if needed. They are lightweight and do a good job of assessing performance issues, allowing drill through into various areas. You need to be on SQL 2005 SP2 to use them. No other requirements and they are free. Check the following link for a brief overview and a link to the download: http://blogs.msdn.com/sqltips/archive/2007/03/29/sql-server-2005-performance-dashboard-reports.aspx

-Sue

Performance ?

If I set the performance monitor alert on the production machine so is there
any performance issue ?
Hi,
No issues, But select only required counters. See the below site, it defines
about lots of good monitoring counters
http://www.sql-server-performance.com
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:E4CA1ECE-8015-4186-8CAB-3315CBE32474@.microsoft.com...
> If I set the performance monitor alert on the production machine so is
> there
> any performance issue ?

Performace montior

HI..
I have window s server 2003 with swl server 2000 sp3
I need to monitor some sql memory counter for that i have start preformace
counter for sql but when i will try to start that couter in prefomance
monitor it gives me following error
"The service was unable to add the counter '\SQLServer:Memory
Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
log or alert will continue, but data for that counter will not be collected.
The error returned is: The specified object is not found on the system.
.. "
also i check that i am administrator and i login as administrator
pls help
-TP
Hi,
I had problem with SQL performance counters and following article helped me
to solve my problem.
If you see any error messages in SQL Error Log like:
Performance monitor shared memory setup failed: -1
Then check the article:
http://support.microsoft.com/default...812915&sd=tech
Which account are you using in Performance Logs and Alerts service?
Did you try LODCTR, UNLODCTR?
"tp" wrote:

> HI..
> I have window s server 2003 with swl server 2000 sp3
> I need to monitor some sql memory counter for that i have start preformace
> counter for sql but when i will try to start that couter in prefomance
> monitor it gives me following error
> "The service was unable to add the counter '\SQLServer:Memory
> Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
> log or alert will continue, but data for that counter will not be collected.
> The error returned is: The specified object is not found on the system.
> . "
> also i check that i am administrator and i login as administrator
> pls help
> -TP
>

Performace montior

HI..
I have window s server 2003 with swl server 2000 sp3
I need to monitor some sql memory counter for that i have start preformace
counter for sql but when i will try to start that couter in prefomance
monitor it gives me following error
"The service was unable to add the counter '\SQLServer:Memory
Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
log or alert will continue, but data for that counter will not be collected.
The error returned is: The specified object is not found on the system.
. "
also i check that i am administrator and i login as administrator
pls help
-TPHi,
I had problem with SQL performance counters and following article helped me
to solve my problem.
If you see any error messages in SQL Error Log like:
Performance monitor shared memory setup failed: -1
Then check the article:
http://support.microsoft.com/defaul...;812915&sd=tech
Which account are you using in Performance Logs and Alerts service?
Did you try LODCTR, UNLODCTR?
"tp" wrote:

> HI..
> I have window s server 2003 with swl server 2000 sp3
> I need to monitor some sql memory counter for that i have start preforma
ce
> counter for sql but when i will try to start that couter in prefomance
> monitor it gives me following error
> "The service was unable to add the counter '\SQLServer:Memory
> Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
> log or alert will continue, but data for that counter will not be collecte
d.
> The error returned is: The specified object is not found on the system.
> . "
> also i check that i am administrator and i login as administrator
> pls help
> -TP
>

Performace montior

HI..
I have window s server 2003 with swl server 2000 sp3
I need to monitor some sql memory counter for that i have start preformace
counter for sql but when i will try to start that couter in prefomance
monitor it gives me following error
"The service was unable to add the counter '\SQLServer:Memory
Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
log or alert will continue, but data for that counter will not be collected.
The error returned is: The specified object is not found on the system.
. "
also i check that i am administrator and i login as administrator
pls help
-TPHi,
I had problem with SQL performance counters and following article helped me
to solve my problem.
If you see any error messages in SQL Error Log like:
Performance monitor shared memory setup failed: -1
Then check the article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&sd=tech
Which account are you using in Performance Logs and Alerts service?
Did you try LODCTR, UNLODCTR?
"tp" wrote:
> HI..
> I have window s server 2003 with swl server 2000 sp3
> I need to monitor some sql memory counter for that i have start preformace
> counter for sql but when i will try to start that couter in prefomance
> monitor it gives me following error
> "The service was unable to add the counter '\SQLServer:Memory
> Manager\Connection Memory (KB)' to the SQLServerMemory log or alert. This
> log or alert will continue, but data for that counter will not be collected.
> The error returned is: The specified object is not found on the system.
> . "
> also i check that i am administrator and i login as administrator
> pls help
> -TP
>

Performace Monitor in Windows 2000

PerfMon under NT has a 'Always on top' option but the same
option can not be found in Windows 2000. Any ideas?
thanksHello,
My name is Michael and I would like to thank you for using Microsoft
newsgroup.
Under Windows NT, this feature is application-specific. So far as I know,
the option 'Always on top' does not exist in the performance application in
Windows 2000. That is by design so what we are able to do unfortunately is
very limited in Windows 2000.
Thanks for using Microsoft newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hello,
Due to the anture of this issue, I think the current newsgroup is not the
best one for this problem. I would suggest that you post this question in
the microsoft.public.win2000.general newsgroup, which is primarily for
issues involving windows 2000 problem. The reason why we recommend posting
appropriately is you will get the most qualified pool of respondents, and
other partners who read the newsgroups regularly can either share their
knowledge or learn from your interaction with us. I hope the problem can be
resolved quickly.
Thank you for using our newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Performace Monitor and SQL Profiler

Hi,
I was running Performace Monitor and SQL Profiler to keep track of
changes on the server for period of a week. And for some reason this ONE
table keeps getting locked out. The third party vendor suggested that SQL
Profiler creates locks again the users database.
I though the SQL Profiler acquire any locks against user databases, it is
getting information form SQL API directly?
Also the performace counters I read had no affect on the SQL Server...
Is my understanding wrong? Can someone clearify it for me? Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005Well... I'm not sure if SQL Profiler may cause locks or not however
Microsoft recommends using these kind of tools (SQL Profiler, Performance
Monitor) from another machine. Because they effect performance on the
machine they work. However, in this case they also recommend using a
dedicated connection between those two machines to avoid network traffic
because of using these tools if possible.
So, in your case, yes, they have affect on the SQL Server somehow.
--
Ekrem Ã?nsoy
"Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
news:E838BE3D-DDAF-46C3-A9B0-7F102C59D806@.microsoft.com...
> Hi,
> I was running Performace Monitor and SQL Profiler to keep track of
> changes on the server for period of a week. And for some reason this ONE
> table keeps getting locked out. The third party vendor suggested that SQL
> Profiler creates locks again the users database.
> I though the SQL Profiler acquire any locks against user databases, it is
> getting information form SQL API directly?
> Also the performace counters I read had no affect on the SQL Server...
> Is my understanding wrong? Can someone clearify it for me? Thanks!
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005|||I see, I will have to check that out on if it has any affect on user database
or not. But today I did a trace that logged about 250,000 records on
another database, and that server didn't notice any deadlocks or lock
timeouts. But I did take your advice and this time ran the SQL Monitor on a
different computer. So maybe that had some affect.
So I do suspect me running it on the serer caused locks but might have
caused some slow down. So I think the application is either timing out too
quickly or something else is a miss. Thank-you for your reply.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem Ã?nsoy" wrote:
> Well... I'm not sure if SQL Profiler may cause locks or not however
> Microsoft recommends using these kind of tools (SQL Profiler, Performance
> Monitor) from another machine. Because they effect performance on the
> machine they work. However, in this case they also recommend using a
> dedicated connection between those two machines to avoid network traffic
> because of using these tools if possible.
> So, in your case, yes, they have affect on the SQL Server somehow.
> --
> Ekrem Ã?nsoy
>
> "Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
> news:E838BE3D-DDAF-46C3-A9B0-7F102C59D806@.microsoft.com...
> > Hi,
> >
> > I was running Performace Monitor and SQL Profiler to keep track of
> > changes on the server for period of a week. And for some reason this ONE
> > table keeps getting locked out. The third party vendor suggested that SQL
> > Profiler creates locks again the users database.
> >
> > I though the SQL Profiler acquire any locks against user databases, it is
> > getting information form SQL API directly?
> >
> > Also the performace counters I read had no affect on the SQL Server...
> >
> > Is my understanding wrong? Can someone clearify it for me? Thanks!
> >
> > --
> > Mohit K. Gupta
> > B.Sc. CS, Minor Japanese
> > MCTS: SQL Server 2005
>|||Hi
SQL Profiler will not create database locks unless you are logging to a
database table, which is not usually recommended. In whioch case it is
unlikely that other applications are using that table (or database!)
If you can't log from a separate machine on a dedicated lan, you can use a
server side trace. Make sure that any trace files are not using the same
discs as SQL Server preferrably have fast spindles for it's exclusive use
(although this is rarely possible!)
If you use the SQL Profiler GUI it will use space on the TEMP directory
(even if logging to a file) make sure that this is not the system disc as
running out of space on that, will cause the system to hang.
John
"Mohit K. Gupta" wrote:
> I see, I will have to check that out on if it has any affect on user database
> or not. But today I did a trace that logged about 250,000 records on
> another database, and that server didn't notice any deadlocks or lock
> timeouts. But I did take your advice and this time ran the SQL Monitor on a
> different computer. So maybe that had some affect.
> So I do suspect me running it on the serer caused locks but might have
> caused some slow down. So I think the application is either timing out too
> quickly or something else is a miss. Thank-you for your reply.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem Ã?nsoy" wrote:
> > Well... I'm not sure if SQL Profiler may cause locks or not however
> > Microsoft recommends using these kind of tools (SQL Profiler, Performance
> > Monitor) from another machine. Because they effect performance on the
> > machine they work. However, in this case they also recommend using a
> > dedicated connection between those two machines to avoid network traffic
> > because of using these tools if possible.
> >
> > So, in your case, yes, they have affect on the SQL Server somehow.
> >
> > --
> > Ekrem Ã?nsoy
> >
> >
> >
> > "Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
> > news:E838BE3D-DDAF-46C3-A9B0-7F102C59D806@.microsoft.com...
> > > Hi,
> > >
> > > I was running Performace Monitor and SQL Profiler to keep track of
> > > changes on the server for period of a week. And for some reason this ONE
> > > table keeps getting locked out. The third party vendor suggested that SQL
> > > Profiler creates locks again the users database.
> > >
> > > I though the SQL Profiler acquire any locks against user databases, it is
> > > getting information form SQL API directly?
> > >
> > > Also the performace counters I read had no affect on the SQL Server...
> > >
> > > Is my understanding wrong? Can someone clearify it for me? Thanks!
> > >
> > > --
> > > Mohit K. Gupta
> > > B.Sc. CS, Minor Japanese
> > > MCTS: SQL Server 2005
> >|||Thanks Guys ;-).
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Bell" wrote:
> Hi
> SQL Profiler will not create database locks unless you are logging to a
> database table, which is not usually recommended. In whioch case it is
> unlikely that other applications are using that table (or database!)
> If you can't log from a separate machine on a dedicated lan, you can use a
> server side trace. Make sure that any trace files are not using the same
> discs as SQL Server preferrably have fast spindles for it's exclusive use
> (although this is rarely possible!)
> If you use the SQL Profiler GUI it will use space on the TEMP directory
> (even if logging to a file) make sure that this is not the system disc as
> running out of space on that, will cause the system to hang.
> John
> "Mohit K. Gupta" wrote:
> > I see, I will have to check that out on if it has any affect on user database
> > or not. But today I did a trace that logged about 250,000 records on
> > another database, and that server didn't notice any deadlocks or lock
> > timeouts. But I did take your advice and this time ran the SQL Monitor on a
> > different computer. So maybe that had some affect.
> >
> > So I do suspect me running it on the serer caused locks but might have
> > caused some slow down. So I think the application is either timing out too
> > quickly or something else is a miss. Thank-you for your reply.
> >
> > --
> > Mohit K. Gupta
> > B.Sc. CS, Minor Japanese
> > MCTS: SQL Server 2005
> >
> >
> > "Ekrem Ã?nsoy" wrote:
> >
> > > Well... I'm not sure if SQL Profiler may cause locks or not however
> > > Microsoft recommends using these kind of tools (SQL Profiler, Performance
> > > Monitor) from another machine. Because they effect performance on the
> > > machine they work. However, in this case they also recommend using a
> > > dedicated connection between those two machines to avoid network traffic
> > > because of using these tools if possible.
> > >
> > > So, in your case, yes, they have affect on the SQL Server somehow.
> > >
> > > --
> > > Ekrem Ã?nsoy
> > >
> > >
> > >
> > > "Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
> > > news:E838BE3D-DDAF-46C3-A9B0-7F102C59D806@.microsoft.com...
> > > > Hi,
> > > >
> > > > I was running Performace Monitor and SQL Profiler to keep track of
> > > > changes on the server for period of a week. And for some reason this ONE
> > > > table keeps getting locked out. The third party vendor suggested that SQL
> > > > Profiler creates locks again the users database.
> > > >
> > > > I though the SQL Profiler acquire any locks against user databases, it is
> > > > getting information form SQL API directly?
> > > >
> > > > Also the performace counters I read had no affect on the SQL Server...
> > > >
> > > > Is my understanding wrong? Can someone clearify it for me? Thanks!
> > > >
> > > > --
> > > > Mohit K. Gupta
> > > > B.Sc. CS, Minor Japanese
> > > > MCTS: SQL Server 2005
> > >

Performace Monitor and SQL Profiler

I see, I will have to check that out on if it has any affect on user database
or not. But today I did a trace that logged about 250,000 records on
another database, and that server didn't notice any deadlocks or lock
timeouts. But I did take your advice and this time ran the SQL Monitor on a
different computer. So maybe that had some affect.
So I do suspect me running it on the serer caused locks but might have
caused some slow down. So I think the application is either timing out too
quickly or something else is a miss. Thank-you for your reply.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Ekrem ?nsoy" wrote:

> Well... I'm not sure if SQL Profiler may cause locks or not however
> Microsoft recommends using these kind of tools (SQL Profiler, Performance
> Monitor) from another machine. Because they effect performance on the
> machine they work. However, in this case they also recommend using a
> dedicated connection between those two machines to avoid network traffic
> because of using these tools if possible.
> So, in your case, yes, they have affect on the SQL Server somehow.
> --
> Ekrem ?nsoy
>
> "Mohit K. Gupta" <mohitkgupta@.msn.com> wrote in message
> news:E838BE3D-DDAF-46C3-A9B0-7F102C59D806@.microsoft.com...
>
Hi
SQL Profiler will not create database locks unless you are logging to a
database table, which is not usually recommended. In whioch case it is
unlikely that other applications are using that table (or database!)
If you can't log from a separate machine on a dedicated lan, you can use a
server side trace. Make sure that any trace files are not using the same
discs as SQL Server preferrably have fast spindles for it's exclusive use
(although this is rarely possible!)
If you use the SQL Profiler GUI it will use space on the TEMP directory
(even if logging to a file) make sure that this is not the system disc as
running out of space on that, will cause the system to hang.
John
"Mohit K. Gupta" wrote:
[vbcol=seagreen]
> I see, I will have to check that out on if it has any affect on user database
> or not. But today I did a trace that logged about 250,000 records on
> another database, and that server didn't notice any deadlocks or lock
> timeouts. But I did take your advice and this time ran the SQL Monitor on a
> different computer. So maybe that had some affect.
> So I do suspect me running it on the serer caused locks but might have
> caused some slow down. So I think the application is either timing out too
> quickly or something else is a miss. Thank-you for your reply.
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> "Ekrem ?nsoy" wrote:
|||Thanks Guys ;-).
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> SQL Profiler will not create database locks unless you are logging to a
> database table, which is not usually recommended. In whioch case it is
> unlikely that other applications are using that table (or database!)
> If you can't log from a separate machine on a dedicated lan, you can use a
> server side trace. Make sure that any trace files are not using the same
> discs as SQL Server preferrably have fast spindles for it's exclusive use
> (although this is rarely possible!)
> If you use the SQL Profiler GUI it will use space on the TEMP directory
> (even if logging to a file) make sure that this is not the system disc as
> running out of space on that, will cause the system to hang.
> John
> "Mohit K. Gupta" wrote:

Perfomance monitor

Hi all,
I am thinking how bad it can be if I have perfomance monitor and sql
profiler running for my production SQL server? do they affact the perfomance
a lot? If there a better way for me to do the samilar thing?
Thanks.See if this helps:
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Tips On Using the SQL Server Profiler
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
Tips for Using Performance Monitor
http://www.sql-server-performance.com/performance_monitor_tips.asp
AMB
"Catelin Wang" wrote:
> Hi all,
> I am thinking how bad it can be if I have perfomance monitor and sql
> profiler running for my production SQL server? do they affact the perfomance
> a lot? If there a better way for me to do the samilar thing?
> Thanks.|||Very good infomation. Thanks a lot .
"Alejandro Mesa" wrote:
> See if this helps:
> Automating Server Side Tracing in SQL Server
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
> Tips On Using the SQL Server Profiler
> http://www.sql-server-performance.com/sql_server_profiler_tips.asp
> Tips for Using Performance Monitor
> http://www.sql-server-performance.com/performance_monitor_tips.asp
>
> AMB
> "Catelin Wang" wrote:
> > Hi all,
> > I am thinking how bad it can be if I have perfomance monitor and sql
> > profiler running for my production SQL server? do they affact the perfomance
> > a lot? If there a better way for me to do the samilar thing?
> >
> > Thanks.

Perfomance monitor

Hi all,
I am thinking how bad it can be if I have perfomance monitor and sql
profiler running for my production SQL server? do they affact the perfomanc
e
a lot? If there a better way for me to do the samilar thing?
Thanks.See if this helps:
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_sid..._sql_server.htm
Tips On Using the SQL Server Profiler
http://www.sql-server-performance.c...ofiler_tips.asp
Tips for Using Performance Monitor
http://www.sql-server-performance.c...onitor_tips.asp
AMB
"Catelin Wang" wrote:

> Hi all,
> I am thinking how bad it can be if I have perfomance monitor and sql
> profiler running for my production SQL server? do they affact the perfoma
nce
> a lot? If there a better way for me to do the samilar thing?
> Thanks.|||Very good infomation. Thanks a lot .
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Automating Server Side Tracing in SQL Server
> http://vyaskn.tripod.com/server_sid..._sql_server.htm
> Tips On Using the SQL Server Profiler
> http://www.sql-server-performance.c...ofiler_tips.asp
> Tips for Using Performance Monitor
> http://www.sql-server-performance.c...onitor_tips.asp
>
> AMB
> "Catelin Wang" wrote:
>

Perfomance monitor

Hi all,
I am thinking how bad it can be if I have perfomance monitor and sql
profiler running for my production SQL server? do they affact the perfomance
a lot? If there a better way for me to do the samilar thing?
Thanks.
See if this helps:
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_side...sql_server.htm
Tips On Using the SQL Server Profiler
http://www.sql-server-performance.co...filer_tips.asp
Tips for Using Performance Monitor
http://www.sql-server-performance.co...nitor_tips.asp
AMB
"Catelin Wang" wrote:

> Hi all,
> I am thinking how bad it can be if I have perfomance monitor and sql
> profiler running for my production SQL server? do they affact the perfomance
> a lot? If there a better way for me to do the samilar thing?
> Thanks.
|||Very good infomation. Thanks a lot .
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> See if this helps:
> Automating Server Side Tracing in SQL Server
> http://vyaskn.tripod.com/server_side...sql_server.htm
> Tips On Using the SQL Server Profiler
> http://www.sql-server-performance.co...filer_tips.asp
> Tips for Using Performance Monitor
> http://www.sql-server-performance.co...nitor_tips.asp
>
> AMB
> "Catelin Wang" wrote:

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/defaul...kb;en-us;227662
http://support.microsoft.com/defaul...kb;en-us;246328
http://www.extremeexperts.com/sql/f...erCounters.aspx
HTH,
Paul Ibison

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/default.aspx?scid=kb;en-us;227662
http://support.microsoft.com/default.aspx?scid=kb;en-us;246328
http://www.extremeexperts.com/sql/faq/EnablingPerCounters.aspx
HTH,
Paul Ibison

Perfmon.exe doesn't have SQLserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:1c53b01c4524b$06f48710$a401280a@.phx.gbl...
> I am trying to use Windows Performance monitor to find
> trouble areas of our sql server. When I run perfmon.exe I
> do not have a SQLServer object from which I can select
> counters. If this is a sql server how do I add the
> sqlserver object to perfmon?
If you are talking about SQL Server 2000, you may want to re-apply SP3a.
Failing this step, you may want to give this a read
http://support.microsoft.com/default...&Product=sql2k
Steve

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?
Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/default...b;en-us;227662
http://support.microsoft.com/default...b;en-us;246328
http://www.extremeexperts.com/sql/fa...rCounters.aspx
HTH,
Paul Ibison