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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Monitoring to prevention of ORACLE for SQL SERVER

Author  Topic 

jose.duarte
Starting Member

2 Posts

Posted - 2006-06-07 : 10:48:51
Hello

I will be that someone is going to do me the mail of
this monitoring for prevention of ORACLE for SQL SERVER
Like 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 Fridays
Tablespaces |at 10AM.
---------------------------------------------------
Consume of temporary |TO each 30 minutes.
segment |Barely of Monday
|to Friday.
---------------------------------------------------
Verification of the |
oracle intermediate |TO each 15 minutes.
---------------------------------------------------

Fulfilly

José Júlio Duarte
   

- Advertisement -