SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Monitor Tool


SQL Server Monitor Tool

Author
Message
Thamizh
Thamizh
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 520
Hi all,

I Planned to develop a SQL Server Monitor Tool .Is there any idea to give?This tool gonna be keep fetch details on multiple sql servers and poped to the users.Still i dont have a idea but i fixed the tool should be in Dot Net 2005.If the is simple its also good to perform.Please need help.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98979 Visits: 33014
You're entering into a pretty crowded field. There are tons & tons of monitoring tools out there. The only advice I can give you is that you need a hook, something that no one else has thought of. If you're just capturing standard performance metrics, what sets you apart from SQL Sentry, Confio Ignite, Idera Diagnostic Manager, Microsoft Operations Manager, Quest Foglight, Red Gate SQL Prompt... and those are just the ones I thought of off the top of my head. Wait until you do a google search on the topic.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
MannySingh
MannySingh
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3051 Visits: 787
I agree with Grant.
But if you are still inclined to develop the system, you can use SQL Profiler to Capture certain Queries based on events and conditions. Read more SQL Internals, Read more about building Graphsv(if your tool does not show me those beautiful graphs, i ain't gonna buy it) and build a better tool, that is not a resource hog, and do not test this against a prod server. Smile

Maninder
www.dbanation.com
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98979 Visits: 33014
Good advice. Take a look at the SQL Server Dynamic Management Views. They're an amazing window into what's going on inside SQL Server. Most of the monitoring tools leverage them in some way.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Thamizh
Thamizh
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 520
Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and its takes huge memory of users machine.we cant follow that's y we planned to develop.can any one guide me to categorize only sensitive alerts like performance ,system etc.. the challenge is to incorporate the production servers in farms and club in to one server with low memory usage .
Schadenfreude-Mei
Schadenfreude-Mei
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3699 Visits: 1336
Thamizh (5/4/2010)
Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and its takes huge memory of users machine.we cant follow that's y we planned to develop.can any one guide me to categorize only sensitive alerts like performance ,system etc.. the challenge is to incorporate the production servers in farms and club in to one server with low memory usage .


Question: Everyone has been commenting as though you intend to go to market with a new product, the way i read this is that you just want to build an in-house monitoring tool.

Which is it?

If your not planning to develop (and then sell) a product, why do you not buy one? Idera DM is very good and is not too resource hungry.

Otherwise if all you want is SQL stats, you can right an ssis to go across linked servers and bring back logs or run sp's to get out user, database, disk stats etc.

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98979 Visits: 33014
Schadenfreude-Mei (5/5/2010)
Thamizh (5/4/2010)
Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and its takes huge memory of users machine.we cant follow that's y we planned to develop.can any one guide me to categorize only sensitive alerts like performance ,system etc.. the challenge is to incorporate the production servers in farms and club in to one server with low memory usage .


Question: Everyone has been commenting as though you intend to go to market with a new product, the way i read this is that you just want to build an in-house monitoring tool.

Which is it?

If your not planning to develop (and then sell) a product, why do you not buy one? Idera DM is very good and is not too resource hungry.

Otherwise if all you want is SQL stats, you can right an ssis to go across linked servers and bring back logs or run sp's to get out user, database, disk stats etc.


That is true. I assumed, because you were talking right off about coding, that you wanted to build a comercial product. If you're just trying to build some internal monitoring tools, you should look at what's available for free from Microsoft, or simply look to leverage the same things through PowerShell or whatever coding language you like best.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98979 Visits: 33014
Thamizh (5/4/2010)
Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and its takes huge memory of users machine.we cant follow that's y we planned to develop.can any one guide me to categorize only sensitive alerts like performance ,system etc.. the challenge is to incorporate the production servers in farms and club in to one server with low memory usage .


You may want to simply cut down the number and size of rules & monitors that are running in SCOM. We use it across our enterprise and haven't seen it hurting performance, but we're pretty careful about which things we enable and which we don't.

We're hitting the same issues you are about the alerts. It's hard to tune it down to make it mostly signal and very little noise.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Thamizh
Thamizh
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 520
I will consider this
nycdotnet
nycdotnet
SSC Veteran
SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)SSC Veteran (269 reputation)

Group: General Forum Members
Points: 269 Visits: 363
Hey there,

If you already have Ops Manager, you're going to have a very difficult time writing something that's better from scratch. If you want something that's very lightweight, consider turning off all the management packs you don't want. For SQL Servers, you should be fine running just the Windows Server and SQL MPs. Also, be sure your Ops Manager environment is patched up (SP1 is out I think) and that you have updated your management packs. Microsoft releases fixes and enhancements for the management packs two or three times per year - the SQL one was updated in November.

Rather than writing a tool from scratch, consider turning off all the features of the SQL Management pack and then slowly read through each item and enable it if you think it's applicable. Each of the Management Packs comes with a Word doc that explains all of the settings. You will end up with a very customized monitoring environment that alerts only on errors YOU care about on YOUR servers that also happens to plug in to a worldclass Enterprise monitoring system. And you didn't even have to write the plumbing yourself.

I don't mean to discourage you from writing your own tool - as a developer with a systems background I definitely feel the urge to do this from time to time. I just think it's really going to be tough for you to write something better than what you could get with the time investment it would take to really optimize an Ops Manager environment (assuming you have the access to do so).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search