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?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?
>|||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?
>