More Chart Palettes?

is there a way to expand the out of box Chart Palettes? It is very limited

Check the following blog article with a sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

-- Robert

monitoring sql server box

I would like to find out if there are any free tools that could be used to
monitor a sql instance and list the
a. most frequently run stored procedures and how long each takes
b. most frequently run views and how long each takes
netiq used to have app manager - is that still available ?
also, which free tool can I use to monitor CPU, Memory and Netwok
Utilization for a windows box running SQL Server 2000 ?
Thanks"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
Not sure about a. & b. but Windows Performance monitor (under Administrative
Tools) can monitor the rest, plus a lot of SQL specific items, too. You can
even monitor remotely.|||Hi John
You could use SQL profiler for a but I would not continually sample. You can
not "run" a view so b is not possible. You may want to look at
http://www.sqldbatips.com/showcode.asp?ID=7.
John
"John Smith" wrote:
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
>|||John Smith wrote:
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
You can capture stored procedure activity using Profiler, and then
analyze the resulting logs. There is a tool available for download here
(http://www.cleardata.biz/cleartrace/instructions.aspx) that will neatly
summarize the log activity, or you can do the same thing yourself, as we do.
Perfmon is your best bet for monitoring CPU, memory, and network
utilization.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||NetIQ sold th app manager for SQL off to Idera and it is now their SQLdm
product. I should say that the Idera SQMdm product started as the NetIQ App
Manager for SQL. They have spent some time and money upgrading and
updating it since purchasing the software.
www.idera.com if you want to check it out.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
>I would like to find out if there are any free tools that could be used to
>monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>

monitoring sql server box

I would like to find out if there are any free tools that could be used to
monitor a sql instance and list the
a. most frequently run stored procedures and how long each takes
b. most frequently run views and how long each takes
netiq used to have app manager - is that still available ?
also, which free tool can I use to monitor CPU, Memory and Netwok
Utilization for a windows box running SQL Server 2000 ?
Thanks"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
Not sure about a. & b. but Windows Performance monitor (under Administrative
Tools) can monitor the rest, plus a lot of SQL specific items, too. You can
even monitor remotely.|||Hi John
You could use SQL profiler for a but I would not continually sample. You can
not "run" a view so b is not possible. You may want to look at
http://www.sqldbatips.com/showcode.asp?ID=7.
John
"John Smith" wrote:

> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
>|||John Smith wrote:
> I would like to find out if there are any free tools that could be used to
> monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>
You can capture stored procedure activity using Profiler, and then
analyze the resulting logs. There is a tool available for download here
(http://www.cleardata.biz/cleartrace/instructions.aspx) that will neatly
summarize the log activity, or you can do the same thing yourself, as we do.
Perfmon is your best bet for monitoring CPU, memory, and network
utilization.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||NetIQ sold th app manager for SQL off to Idera and it is now their SQLdm
product. I should say that the Idera SQMdm product started as the NetIQ App
Manager for SQL. They have spent some time and money upgrading and
updating it since purchasing the software.
www.idera.com if you want to check it out.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Smith" <bukusu@.gmail.com> wrote in message
news:epVak7yuGHA.4756@.TK2MSFTNGP04.phx.gbl...
>I would like to find out if there are any free tools that could be used to
>monitor a sql instance and list the
> a. most frequently run stored procedures and how long each takes
> b. most frequently run views and how long each takes
> netiq used to have app manager - is that still available ?
> also, which free tool can I use to monitor CPU, Memory and Netwok
> Utilization for a windows box running SQL Server 2000 ?
> Thanks
>

Monitoring connections

I have been ask to monito the connections on an MSSQL2000 box. If the
connections are greater than 50, this gentlemen would like an email. Any
suggestions on how I can accomplish this? Can I use an Alert? If so, could
you point me in the direction of how to implement it?
Thanks,
Jeff
Jeff wrote:
> I have been ask to monito the connections on an MSSQL2000 box. If the
> connections are greater than 50, this gentlemen would like an email.
> Any suggestions on how I can accomplish this? Can I use an Alert?
> If so, could you point me in the direction of how to implement it?
> Thanks,
> Jeff
You can easily define the alert from SQL EM (SQL Server Agent needs to
be running). Here's the SQL to do it manually. THe easiest way to do
this is from SQL EM and then script out the T-SQL and modify
accordingly.
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
-- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
@.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
@.notification_message = N'SQL Server now has over 50 connections',
@.performance_condition = N'SQLServer:General Statistics|User
Connections||>|50', @.include_event_description_in = 5, @.category_name =
N'[Uncategorized]'
EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
@.operator_name = N'Operator Name', @.notification_method = 1
END
David Gugick
Imceda Software
www.imceda.com
|||First, thanks for the help. I do have another question that I just can't
seem to figure out. I get this error message when executing the code:
Server: Msg 14262, Level 16, State 1, Procedure
sp_verify_performance_condition, Line 46
The specified object_name ('SQLServer:General Statistics') does not exist.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_notification, Line
26
The specified @.alert_name ('Over50') does not exist.
Any idea what is wrong?
Thanks,
Jeff
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
> Jeff wrote:
> You can easily define the alert from SQL EM (SQL Server Agent needs to
> be running). Here's the SQL to do it manually. THe easiest way to do
> this is from SQL EM and then script out the T-SQL and modify
> accordingly.
> IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
> -- Delete the alert with the same name.
> EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
> BEGIN
> EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
> @.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
> @.notification_message = N'SQL Server now has over 50 connections',
> @.performance_condition = N'SQLServer:General Statistics|User
> Connections||>|50', @.include_event_description_in = 5, @.category_name =
> N'[Uncategorized]'
> EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
> @.operator_name = N'Operator Name', @.notification_method = 1
> END
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
|||Jeff wrote:[vbcol=seagreen]
> First, thanks for the help. I do have another question that I just
> can't seem to figure out. I get this error message when executing
> the code:
> Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_performance_condition, Line 46
> The specified object_name ('SQLServer:General Statistics') does not
> exist. Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_notification, Line 26
> The specified @.alert_name ('Over50') does not exist.
> Any idea what is wrong?
> Thanks,
> Jeff
>
> "David Gugick" <davidg-nospam@.imceda.com> wrote in message
> news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
Create the alert in SQL EM yourself and then script it out. The code I
sent may be somehow linked to my setup. Make sure the SQL Server Agent
is running. If your performance counters are missing, you'll probably
see this from SQL EM.
David Gugick
Imceda Software
www.imceda.com

Monitoring connections

I have been ask to monito the connections on an MSSQL2000 box. If the
connections are greater than 50, this gentlemen would like an email. Any
suggestions on how I can accomplish this? Can I use an Alert? If so, could
you point me in the direction of how to implement it?
Thanks,
JeffJeff wrote:
> I have been ask to monito the connections on an MSSQL2000 box. If the
> connections are greater than 50, this gentlemen would like an email.
> Any suggestions on how I can accomplish this? Can I use an Alert?
> If so, could you point me in the direction of how to implement it?
> Thanks,
> Jeff
You can easily define the alert from SQL EM (SQL Server Agent needs to
be running). Here's the SQL to do it manually. THe easiest way to do
this is from SQL EM and then script out the T-SQL and modify
accordingly.
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
-- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
@.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
@.notification_message = N'SQL Server now has over 50 connections',
@.performance_condition = N'SQLServer:General Statistics|User
Connections||>|50', @.include_event_description_in = 5, @.category_name =
N'[Uncategorized]'
EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
@.operator_name = N'Operator Name', @.notification_method = 1
END
David Gugick
Imceda Software
www.imceda.com|||First, thanks for the help. I do have another question that I just can't
seem to figure out. I get this error message when executing the code:
Server: Msg 14262, Level 16, State 1, Procedure
sp_verify_performance_condition, Line 46
The specified object_name ('SQLServer:General Statistics') does not exist.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_notification, Line
26
The specified @.alert_name ('Over50') does not exist.
Any idea what is wrong?
Thanks,
Jeff
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
> Jeff wrote:
> You can easily define the alert from SQL EM (SQL Server Agent needs to
> be running). Here's the SQL to do it manually. THe easiest way to do
> this is from SQL EM and then script out the T-SQL and modify
> accordingly.
> IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
> -- Delete the alert with the same name.
> EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
> BEGIN
> EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
> @.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
> @.notification_message = N'SQL Server now has over 50 connections',
> @.performance_condition = N'SQLServer:General Statistics|User
> Connections||>|50', @.include_event_description_in = 5, @.category_name =
> N'[Uncategorized]'
> EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
> @.operator_name = N'Operator Name', @.notification_method = 1
> END
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Jeff wrote:[vbcol=seagreen]
> First, thanks for the help. I do have another question that I just
> can't seem to figure out. I get this error message when executing
> the code:
> Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_performance_condition, Line 46
> The specified object_name ('SQLServer:General Statistics') does not
> exist. Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_notification, Line 26
> The specified @.alert_name ('Over50') does not exist.
> Any idea what is wrong?
> Thanks,
> Jeff
>
> "David Gugick" <davidg-nospam@.imceda.com> wrote in message
> news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
Create the alert in SQL EM yourself and then script it out. The code I
sent may be somehow linked to my setup. Make sure the SQL Server Agent
is running. If your performance counters are missing, you'll probably
see this from SQL EM.
David Gugick
Imceda Software
www.imceda.com

Monitoring connections

I have been ask to monito the connections on an MSSQL2000 box. If the
connections are greater than 50, this gentlemen would like an email. Any
suggestions on how I can accomplish this? Can I use an Alert? If so, could
you point me in the direction of how to implement it?
Thanks,
JeffJeff wrote:
> I have been ask to monito the connections on an MSSQL2000 box. If the
> connections are greater than 50, this gentlemen would like an email.
> Any suggestions on how I can accomplish this? Can I use an Alert?
> If so, could you point me in the direction of how to implement it?
> Thanks,
> Jeff
You can easily define the alert from SQL EM (SQL Server Agent needs to
be running). Here's the SQL to do it manually. THe easiest way to do
this is from SQL EM and then script out the T-SQL and modify
accordingly.
IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
-- Delete the alert with the same name.
EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
BEGIN
EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
@.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
@.notification_message = N'SQL Server now has over 50 connections',
@.performance_condition = N'SQLServer:General Statistics|User
Connections||>|50', @.include_event_description_in = 5, @.category_name =N'[Uncategorized]'
EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
@.operator_name = N'Operator Name', @.notification_method = 1
END
David Gugick
Imceda Software
www.imceda.com|||First, thanks for the help. I do have another question that I just can't
seem to figure out. I get this error message when executing the code:
Server: Msg 14262, Level 16, State 1, Procedure
sp_verify_performance_condition, Line 46
The specified object_name ('SQLServer:General Statistics') does not exist.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_notification, Line
26
The specified @.alert_name ('Over50') does not exist.
Any idea what is wrong?
Thanks,
Jeff
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
> Jeff wrote:
> > I have been ask to monito the connections on an MSSQL2000 box. If the
> > connections are greater than 50, this gentlemen would like an email.
> > Any suggestions on how I can accomplish this? Can I use an Alert?
> > If so, could you point me in the direction of how to implement it?
> >
> > Thanks,
> > Jeff
> You can easily define the alert from SQL EM (SQL Server Agent needs to
> be running). Here's the SQL to do it manually. THe easiest way to do
> this is from SQL EM and then script out the T-SQL and modify
> accordingly.
> IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'Over50'))
> -- Delete the alert with the same name.
> EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
> BEGIN
> EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
> @.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
> @.notification_message = N'SQL Server now has over 50 connections',
> @.performance_condition = N'SQLServer:General Statistics|User
> Connections||>|50', @.include_event_description_in = 5, @.category_name => N'[Uncategorized]'
> EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
> @.operator_name = N'Operator Name', @.notification_method = 1
> END
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Jeff wrote:
> First, thanks for the help. I do have another question that I just
> can't seem to figure out. I get this error message when executing
> the code:
> Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_performance_condition, Line 46
> The specified object_name ('SQLServer:General Statistics') does not
> exist. Server: Msg 14262, Level 16, State 1, Procedure
> sp_verify_notification, Line 26
> The specified @.alert_name ('Over50') does not exist.
> Any idea what is wrong?
> Thanks,
> Jeff
>
> "David Gugick" <davidg-nospam@.imceda.com> wrote in message
> news:ONEhUiDFFHA.2452@.TK2MSFTNGP09.phx.gbl...
>> Jeff wrote:
>> I have been ask to monito the connections on an MSSQL2000 box. If
>> the connections are greater than 50, this gentlemen would like an
>> email. Any suggestions on how I can accomplish this? Can I use an
>> Alert?
>> If so, could you point me in the direction of how to implement it?
>> Thanks,
>> Jeff
>> You can easily define the alert from SQL EM (SQL Server Agent needs
>> to be running). Here's the SQL to do it manually. THe easiest way to
>> do this is from SQL EM and then script out the T-SQL and modify
>> accordingly.
>> IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name =>> N'Over50')) -- Delete the alert with the same name.
>> EXECUTE msdb.dbo.sp_delete_alert @.name = N'Over50'
>> BEGIN
>> EXECUTE msdb.dbo.sp_add_alert @.name = N'Over50', @.message_id = 0,
>> @.severity = 0, @.enabled = 1, @.delay_between_responses = 1800,
>> @.notification_message = N'SQL Server now has over 50 connections',
>> @.performance_condition = N'SQLServer:General Statistics|User
>> Connections||>|50', @.include_event_description_in = 5,
>> @.category_name = N'[Uncategorized]'
>> EXECUTE msdb.dbo.sp_add_notification @.alert_name = N'Over50',
>> @.operator_name = N'Operator Name', @.notification_method = 1
>> END
>>
>> --
>> David Gugick
>> Imceda Software
>> www.imceda.com
Create the alert in SQL EM yourself and then script it out. The code I
sent may be somehow linked to my setup. Make sure the SQL Server Agent
is running. If your performance counters are missing, you'll probably
see this from SQL EM.
--
David Gugick
Imceda Software
www.imceda.com