Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.
Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.
|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>
Showing posts with label alert. Show all posts
Showing posts with label alert. Show all posts
Friday, February 24, 2012
about set an alert that is about blocking
Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure ?blocked process threshold?, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure â'blocked process thresholdâ', 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> > Hi Guys,
> > I wonder if there is a way that I can setup an alert when there are some
> > tables are blocking for a long time? That mean I can get email or call
> > when
> > blocking is occurred. Thanks.
>
>
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure ?blocked process threshold?, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure â'blocked process thresholdâ', 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> > Hi Guys,
> > I wonder if there is a way that I can setup an alert when there are some
> > tables are blocking for a long time? That mean I can get email or call
> > when
> > blocking is occurred. Thanks.
>
>
about set an alert that is about blocking
Hi Guys,
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>
I wonder if there is a way that I can setup an alert when there are some
tables are blocking for a long time? That mean I can get email or call when
blocking is occurred. Thanks.Iter
In SQL Server 2005
Execute Sp_configure blocked process threshold, 200
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
> Hi Guys,
> I wonder if there is a way that I can setup an alert when there are some
> tables are blocking for a long time? That mean I can get email or call
> when
> blocking is occurred. Thanks.|||Thank you very much. Is there any solution in SQL server 2000?
"Uri Dimant" wrote:
> Iter
> In SQL Server 2005
> Execute Sp_configure ‘blocked process threshold’, 200
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:CF7A5EA6-91D2-4158-A543-19C3576561F1@.microsoft.com...
>
>
Thursday, February 9, 2012
about Alert
Hi all:
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...
> Hi all:
> I want to create a Alert,which can email to me when
> my log file is attach to 90% full.
> How can I do?
> Is there Any samples?
> Thank you!!
> Arron
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...
> Hi all:
> I want to create a Alert,which can email to me when
> my log file is attach to 90% full.
> How can I do?
> Is there Any samples?
> Thank you!!
> Arron
about Alert
Hi all:
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...
quote:
> Hi all:
> I want to create a Alert,which can email to me when
> my log file is attach to 90% full.
> How can I do?
> Is there Any samples?
> Thank you!!
> Arron
Subscribe to:
Posts (Atom)