| Wes Sisk 2005-05-20, 5:45 pm |
| sql query analyzer or from cmd prompt:
osql -E
sp_who2
go
/Wes
-----Original Message-----
From: Erick Bergquist [mailto:erickbe@yahoo.com]
Sent: Friday, May 20, 2005 1:47 PM
To: Wes Sisk; cisco-voip@puck.nether.net
Subject: RE: [cisco-voip] kErrorCDRFilesBackingUp - CDR flat files are
backingup.
How do you do a sp_who2?
Will it list if there are sith tasks running?
--- Wes Sisk <wsisk@cisco.com> wrote:
> Erick,
>
> CDR Load and DBL Maint purge are very intesive ops
> for SQL. scheduling
> those separate sounds like a good start.
>
> to get hard data, schedule a sql job to run during
> you outage windows that
> does 'sp_who2' or stay up to watch 'Revenge of the
> Sith' and then run it
> your self. That will report all sql tasks active,
> who owns them, what they
> are doing, their cpu & diskIO usage etc. Should
> provide a couple of good
> pointers.
>
> /Wes
>
> -----Original Message-----
> From: Erick Bergquist [mailto:erickbe@yahoo.com]
> Sent: Friday, May 20, 2005 12:47 PM
> To: Wes Sisk; cisco-voip@puck.nether.net
> Subject: RE: [cisco-voip] kErrorCDRFilesBackingUp -
> CDR flat files are
> backingup.
>
>
>
> Are you talking about the InsertCDR detailed trace
> or
> a different log file?
>
> The InsertCDR trace at time has a entry at 12:24am
> about reading configurastion, then nothing until
> 12:34am which is the line about 10 minute timeout
> occurred.
>
> The CDR insert process is not stopping/starting by
> itself as PID is same the past few days I've been
> looking on this. I did restart the process once per
> the workaround in the bug id mentioned below. PID
> has
> been same since though.
>
> Nothing in event logs (application, system,
> security)
> at this time other then the database layer monitor
> errors about CDR. Is there some other SQL logs I
> should be looking at?
>
> The IPT SQL job runs at 1am daily. The first error
> occurs before that job starts.
>
> The Database Layer Monitor service maint period is
> at
> 24 hr and runs for 2 hours. 12am to 2am.
>
> The CDR load runs at 19:20 hours for 90 minutes
> Uninhibited load from 18:20 hrs to 05:00 hrs
>
> CDR database purge is set to auto purge after 120
> days.
>
> Someone in cisco discussion forums suggested I also
> restart the database layer monitor service to try to
> clear the problem.
>
> Should we maybe try adjusting time of database layer
> maint period? so it doesn't run at same time as CDR
> Load?
>
> --- Wes Sisk <wsisk@cisco.com> wrote:
> change
> time
> running,
> is
> timing
> the
> what
> Behalf
> CDR
> matches
> working.
> file
> the
> They
> time
> are
> running
> that
> network.
> service
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>
> __________________________________
> Yahoo! Mail Mobile
> Take Yahoo! Mail with you! Check email on your
> mobile phone.
> http://mobile.yahoo.com/learn/mail
>
>
Yahoo! Mail
Stay connected, organized, and protected. Take the tour:
http://tour.mail.yahoo.com/mailtour.html
|