SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


autogrowth


autogrowth

Author
Message
GilaMonster
GilaMonster
SSC Guru
SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)SSC Guru (237K reputation)

Group: General Forum Members
Points: 237533 Visits: 46378
sqlfriends (11/29/2012)
So, it doesnot send any kind of alerts to DBA proactively?


If you've configured alerts, you get alerts. If not, you don't (how would SQL intuit who to send alerts to?)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


MyDoggieJessie
MyDoggieJessie
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12906 Visits: 7444
There are many SQL Server Events, SQL Performance Condition Alerts, as well as WMI Events that can be set up rather easily under SQL Server Agent >> Alerts.

Settings up these alerts gives you the option to specify a response i.e. (notify a particular operator), and additionally specify if you want to Email, Page, or netsend the event should one occur.

These are free :-P

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
sqlfriends
sqlfriends
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11195 Visits: 4217
Thanks, we do have sql agent alerts setup, I wonder if it is the Severity 17- insufficient resources that does the work?
I never got the alert because we have a diskspace check job so I can take care of the space proactively.


But just wonder it is the above insufficient resources alert will be triggered if there is no enough file space for mdf file and ldf file.

Thanks,
MyDoggieJessie
MyDoggieJessie
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12906 Visits: 7444
If you create a custom alert for SQL Error # 1101 or 1105 (not sure exactly which is which, you can Google that) it will send you an alert should your data file become full and it is unable to grow

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
Bhuvnesh
Bhuvnesh
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14042 Visits: 4077
MyDoggieJessie (11/29/2012)
If you create a custom alert for SQL Error # 1101 or 1105 (not sure exactly which is which, you can Google that) it will send you an alert should your data file become full and it is unable to grow
in this case DBA will reactively respond there (DIsk is full now what to do :w00tSmile , but here person should be informed proactively.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search