|
Home > Archive > MS SQL Server > March 2006 > Monitor SQL Server?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Monitor SQL Server?
|
|
|
| Hello,
I have a request from a client to have monitoring of a specific
database in case any errors arise to help them isolate the problem.
Would using Profiler accomplish this? Is there a way to set it up so
it's only logged during working hours?
| |
| Jeff Ericson 2006-03-26, 8:23 pm |
| Yes, you can set a filter to only cature events for a given time period.
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>
>
| |
| John Bell 2006-03-26, 8:23 pm |
| Hi
Look at creating a scheduled server side trace, although if there is alot of
activity you may be logging a significant amount of information. Jasper Smith
has a 1 hour trace http://www.sqldbatips.com/showcode.asp?ID=7 which you can
change to be (say) 9 hours and start before the beginning of the day in a SQL
Agent job.
John
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>
>
|
|
|
|
|