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 |
|
pavel73
Starting Member
3 Posts |
 Posted - 2006-08-15 : 04:28:02
|
| HiQuestionYou are the administrator of a Microsoft Windows 2000 Advanced Server computer. The server is also running SQL Server 2000 and contains a database named Sales. The server is configured as shown in the exhibit. The Sales database is configured by using the default options and increases by 50 MB per day. You want an operator to be notified automatically before the database runs out of disk space. You also want to minimize the amount of administrative overhead necessary for this databaseanswerConfigure System Monitor to log an alert if the hard disk contains less >than 600 MB of free space >Configure SQL Server Agent to send an e-mail message notifying the >operator of the System Monitor alertWhere is it possible to find some information about the sequence of actions that need to be done to be configure SQL Agent as is in the answer, i.e. so it could react on the alert of System Monitor, that are not SQL Server's alerts. Or, if it is possible to describe the action order. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-15 : 06:07:26
|
| You could create a new type of alert from "SQL Server Event Alert" to a "SQL Server Performance Condition Alert".Select "SQLServer:Databases" as object and "Data File(s) Size (KB)" and/or "Log File(s) Size (KB)" as counter(s).This is a start, not a failsafe method.Peter LarssonHelsingborg, Sweden |
 |
|
|
pavel73
Starting Member
3 Posts |
Posted - 2006-08-15 : 06:42:48
|
| Does it mean that I can judge the disk free space from the Data File Size, but not from the disk free space. So the answer is wrong, i.e. it will not be possible to do as in the answer? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-15 : 06:57:54
|
| No. My answer is done from within SQL server and you hav to know to what limit the data files and/or log files can grow to.The answer from the text book says you have to create a system alert within the Performance monitor tool.Peter LarssonHelsingborg, Sweden |
|
|
|
pavel73
Starting Member
3 Posts |
Posted - 2006-08-15 : 07:19:34
|
| It is not very clear to me. Let's do it other way, suppose the data base files do not grow, is it possible to configure SQL Server to perform the mentioned actions while decreasing the disk free space less than 600 MB? |
|
|
|
|
|
|
using counters