guys,
I am looking for any Sql monitoring tool more or less reliable and free for
evaluation.
Does anyone knows...
Regards,> I am looking for any Sql monitoring tool more or less reliable and free
> for
> evaluation.
> Does anyone knows...
Profiler comes with SQL Server, so it is for free.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hey
Assuming you have windows 2k + you can also use the for monitoring IO and
other SQL items with administrative tools.
HTH
"Dejan Sarka" wrote:
> Profiler comes with SQL Server, so it is for free.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
2012年3月8日星期四
2012年2月13日星期一
Any better monitoring for locks and blocking in SQL2005?
Are the facilities for monitoring locks and blocking in SQL2005 better than
2000?
I found that in SQL2000 Enterprise Manager by the time you waited for
"current activity" to refresh, the information could have been and gone.
I'd be interested to hear if you've been using it sucessfully to do this
sort of thing.
If you want something similar to Current Activity, Activity
Monitor in Management Studio is an improvement over the
Current Activity node in Enterprise Manager. Opens in a
separate window, you have a few different view to chose
from, you can set a refresh interval.
2005 also has server level reports such as Blocking
Transactions and Top Transactions by Locks.
But just like Current Activity, you are seeing a snapshot
and you need to refresh. You have more options in 2000 to
understand the blocking, locking if you use queries to
monitor activity and it's somewhat the same in 2005.
However, there are improvements to the monitoring and
details you can get related to locking, blocking. In 2005,
you have a lot more details exposed on the waits. You can
also set up a blocked process threshold and use this with
the Blocked Process Report event class in Profiler, SQL
trace. You can also get detailed historical information
related to locking and blocking from the DMV
Sys.dm_db_index_operational_stats.
The following article has a lot of information on you can
use to monitor blocking, locking issues in 2005:
Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/pro.../tsprfprb.mspx
-Sue
On Thu, 19 Jan 2006 04:50:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>Are the facilities for monitoring locks and blocking in SQL2005 better than
>2000?
>I found that in SQL2000 Enterprise Manager by the time you waited for
>"current activity" to refresh, the information could have been and gone.
>I'd be interested to hear if you've been using it sucessfully to do this
>sort of thing.
|||Night and day, across the board. SQL Server 2000 exposed very limited
information to be able to monitor. SQL Server 2005 has layer after layer
after layer of diagnostics. From DBCC commans through DMVs/DMFs, there
aren't many areas of the engine you can't get at.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"James" <James@.discussions.microsoft.com> wrote in message
news:98B66E56-8895-4040-BA63-056144C882C6@.microsoft.com...
> Are the facilities for monitoring locks and blocking in SQL2005 better
> than
> 2000?
> I found that in SQL2000 Enterprise Manager by the time you waited for
> "current activity" to refresh, the information could have been and gone.
> I'd be interested to hear if you've been using it sucessfully to do this
> sort of thing.
2000?
I found that in SQL2000 Enterprise Manager by the time you waited for
"current activity" to refresh, the information could have been and gone.
I'd be interested to hear if you've been using it sucessfully to do this
sort of thing.
If you want something similar to Current Activity, Activity
Monitor in Management Studio is an improvement over the
Current Activity node in Enterprise Manager. Opens in a
separate window, you have a few different view to chose
from, you can set a refresh interval.
2005 also has server level reports such as Blocking
Transactions and Top Transactions by Locks.
But just like Current Activity, you are seeing a snapshot
and you need to refresh. You have more options in 2000 to
understand the blocking, locking if you use queries to
monitor activity and it's somewhat the same in 2005.
However, there are improvements to the monitoring and
details you can get related to locking, blocking. In 2005,
you have a lot more details exposed on the waits. You can
also set up a blocked process threshold and use this with
the Blocked Process Report event class in Profiler, SQL
trace. You can also get detailed historical information
related to locking and blocking from the DMV
Sys.dm_db_index_operational_stats.
The following article has a lot of information on you can
use to monitor blocking, locking issues in 2005:
Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/pro.../tsprfprb.mspx
-Sue
On Thu, 19 Jan 2006 04:50:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>Are the facilities for monitoring locks and blocking in SQL2005 better than
>2000?
>I found that in SQL2000 Enterprise Manager by the time you waited for
>"current activity" to refresh, the information could have been and gone.
>I'd be interested to hear if you've been using it sucessfully to do this
>sort of thing.
|||Night and day, across the board. SQL Server 2000 exposed very limited
information to be able to monitor. SQL Server 2005 has layer after layer
after layer of diagnostics. From DBCC commans through DMVs/DMFs, there
aren't many areas of the engine you can't get at.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"James" <James@.discussions.microsoft.com> wrote in message
news:98B66E56-8895-4040-BA63-056144C882C6@.microsoft.com...
> Are the facilities for monitoring locks and blocking in SQL2005 better
> than
> 2000?
> I found that in SQL2000 Enterprise Manager by the time you waited for
> "current activity" to refresh, the information could have been and gone.
> I'd be interested to hear if you've been using it sucessfully to do this
> sort of thing.
Any Advice on Monitoring Performance of Processing Cubes in AS2000
Hi,
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure what
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.
standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
|||First, these two white papers:
http://www.microsoft.com/technet/pro.../anservog.mspx
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure what
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.
standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
|||First, these two white papers:
http://www.microsoft.com/technet/pro.../anservog.mspx
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
Any Advice on Monitoring Performance of Processing Cubes in AS2000
Hi,
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure wha
t
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.|||First, these two white papers:
http://www.microsoft.com/technet/pr...n/anservog.mspx
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
I want to monitor an AS2000 installation to see if and where we have any
bottlenecks in the cube processing. Does anyone know of a good document or
advice to offer. I have already read the SQL Server 2000 Resource Kit on
monitoring AS. It lists the counters to examine, but I'm not really sure wha
t
would good figures and what would be poor ones.
We are using a 4 CPU box running Win2003.
The fact tables are stored in a SQL Server 2000 on the same box.
Thanks in advance.standard best practices:
to correctly optimize your server:
1. Process & Monitor
2. change settings (like memory properties of AS)
3. Process & Monitor again...
You'll find the best parameters for your system.
also, try to process your partitions / cubes in parrallel.
put the distinct count measures in a dedicated cube
your better counter is the overall time taken to do your process ;-)
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.|||First, these two white papers:
http://www.microsoft.com/technet/pr...n/anservog.mspx
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Second, configure your server to capture the system-wide processing log file
(run Analysis Manager, right-click on the server and look at the "Logging"
tab of the server properties. This allows you to gather statistics on when
and how long processing took.
Hope that helps.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Al" <Al@.discussions.microsoft.com> wrote in message
news:BA3F3FA0-BE1D-4437-BB9B-161577221AEF@.microsoft.com...
> Hi,
> I want to monitor an AS2000 installation to see if and where we have any
> bottlenecks in the cube processing. Does anyone know of a good document or
> advice to offer. I have already read the SQL Server 2000 Resource Kit on
> monitoring AS. It lists the counters to examine, but I'm not really sure
> what
> would good figures and what would be poor ones.
> We are using a 4 CPU box running Win2003.
> The fact tables are stored in a SQL Server 2000 on the same box.
> Thanks in advance.
订阅：
博文 (Atom)