View using 100% CPU on server

Hi Richard,

Is this a list being generated with SQL code was it added to T_KEYWORD, and then used in the graphical interface of list manager? Perhaps you already did this, but the first thing I would suggest looking at is the actual SQL code used in list manager for one of the broken lists. There may be a bad join or something causing the problem.

_______________________________________________________
David Frederick
Database Applications Analyst
Segerstrom Center for the Arts
600 Town Center Drive, Costa Mesa, CA 92626
T (714) 556-2122 x 4067 E DFrederick@SCFTA.org

Hi -

We wrote a little view that joined contributions with credits so that we could pull lists out of list manager that pulled on TOTAL contributions (i.e. a donor of $5K with a soft credit of $5K comes up as a 10K donor or a donor with 4 gifts of $2500 comes up as a $10K donor). 

It worked like a charm.  As of yesterday (the earlist I know of), it is now taking up 100% of the SQL Server CPU and crashing whatever lists use it.  Has anyone run into this before where a view works like a champ then doesn't?  The view works in SSMS - but pull it throught he client and the processor use goes through the roof.

Any ideas are helpful.  Thanks!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Richard,

Is this a list being generated with SQL code was it added to T_KEYWORD, and then used in the graphical interface of list manager? Perhaps you already did this, but the first thing I would suggest looking at is the actual SQL code used in list manager for one of the broken lists. There may be a bad join or something causing the problem.

_______________________________________________________
David Frederick
Database Applications Analyst
Segerstrom Center for the Arts
600 Town Center Drive, Costa Mesa, CA 92626
T (714) 556-2122 x 4067 E DFrederick@SCFTA.org

Hi -

We wrote a little view that joined contributions with credits so that we could pull lists out of list manager that pulled on TOTAL contributions (i.e. a donor of $5K with a soft credit of $5K comes up as a 10K donor or a donor with 4 gifts of $2500 comes up as a $10K donor). 

It worked like a charm.  As of yesterday (the earlist I know of), it is now taking up 100% of the SQL Server CPU and crashing whatever lists use it.  Has anyone run into this before where a view works like a champ then doesn't?  The view works in SSMS - but pull it throught he client and the processor use goes through the roof.

Any ideas are helpful.  Thanks!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!