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

[ Post a follow-up to this message ]