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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-23 : 22:02:49
|
| Raj writes "HiWe have just started using SQL 2000 server for our organization and my job is administrating SQL server for all of our database needs. ( Windows 2000 sp 2, SQL 2000 sp1 ) I have been trying to create Performance Alerts based on Percent Log Used counter in Windows 2000 administrative Tools. Below is a step by step description given in Microsoft SQL administration book.-Open Enterprise Manager, choose the server, expand Management/SQL Server Agent/Alerts, and add a new alert-select SQL Server Performance Condition Alert-select SQL Server Database objects-select counter Data File size ( Percent Log Used )-Select the database, falls below/above/equal to, and fill in the size value-On the Response tab, select the job to run, and/or the operators to notify via e-mail, pager, etc.I already went through all of these steps. I have successfully created alerts also. Job that Backs up a transaction log is also running successfully when I run it manually. But alert is not fired when it meets performance condition. I tried few different performance condition but none of my alerts are working. I am sure, I am missing something in setting up these performance condition alerts. Can you help me resolve this issue? I appreciate your help.Rajan" |
|
|
|
|
|
Performance condition alert