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 |
jose.duarte
Starting Member
2 Posts |
Posted - 2006-06-07 : 10:48:51
|
HelloI will be that someone is going to do me the mail of this monitoring for prevention of ORACLE for SQL SERVERLike the exemple above:Monitoring |Frequency***************************************************Connectivity to | database |TO each 15 minutes. ---------------------------------------------------Database filles |Daily at 10AM.---------------------------------------------------Max extents (80%) |Daily at 10AM, |12PM e 16PM.---------------------------------------------------Max extents (95%) |TO each 30 minutes.---------------------------------------------------Error in shared pool |Daily at 10AM.---------------------------------------------------Open Cursor |TO each 30 minutes. |Barely between 9 and 22h.---------------------------------------------------Space in partitions | (barely applicable in | systems with | partition) |every hour correct. ---------------------------------------------------Locks |TO each 15 minutes. ---------------------------------------------------Maximum number |of sessions |TO each 15 minutes.---------------------------------------------------Free Space |TO each 15 minutes.---------------------------------------------------Old sessions |Daily at 10AM.---------------------------------------------------Ivalid Indexes |Daily at 10AM.---------------------------------------------------Free space in |Tuesdays and FridaysTablespaces |at 10AM. ---------------------------------------------------Consume of temporary |TO each 30 minutes.segment |Barely of Monday |to Friday. ---------------------------------------------------Verification of the |oracle intermediate |TO each 15 minutes.---------------------------------------------------FulfillyJosé Júlio Duarte |
|
|
|
|