Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shilpakv6
Starting Member
2 Posts |
 Posted - 2014-02-03 : 10:31:44
|
| Hi All, Can any1 advise or give suggestions for me on the below : I work in a noc team(monitoring team) . I have to do a case study on sql. can any1 tell me any case study or context where i can use sql server and present a case study. i should not giv on any third party tools. also we donot use or work on sql server. we use scom and tws as monitoring tools.The case study should be such that it should have post implementation benefits.i hav esearched in google and got many. but sould not find anything apt for monitring team( we monitor application jobs, servers, network devices)Sh |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-02-04 : 01:48:46
|
| As you've mentioned - there are plenty of case studies on the internet. The SQL Server monitoring strategy should based around critical events . By commiting on to many situations monitored – “white noise” can distract from the critical situations. For example, receiving notification on every block – may obfuscate , some critical space full.DBAs are generally busy – assessing every situation can be time consuming – therefore the notifications must be relevant. I would say this is the best benerfit i.e alerting DBAs of critical events is fundamental to a Production database server systemJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
shilpakv6
Starting Member
2 Posts |
Posted - 2014-02-04 : 08:42:03
|
Thank u very much Jack. you gave an insight of prob and solution for the case study. now i ve got bit idea and how to present it. thank again for your help.quote:
Originally posted by jackv
As you've mentioned - there are plenty of case studies on the internet. The SQL Server monitoring strategy should based around critical events . By commiting on to many situations monitored – “white noise” can distract from the critical situations. For example, receiving notification on every block – may obfuscate , some critical space full.DBAs are generally busy – assessing every situation can be time consuming – therefore the notifications must be relevant. I would say this is the best benerfit i.e alerting DBAs of critical events is fundamental to a Production database server systemJack Vamvas--------------------http://www.sqlserver-dba.com
Sh |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-02-08 : 02:08:07
|
| Not a problemJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Case Study On SQL