System Center DB concerns! Microsoft Databases

Question

System Center DB concerns! Microsoft Databases

Staggerlee

SSCertifiable

Points: 5272
More actions
October 17, 2011 at 3:46 am

#250091

Hi all,
We just upgraded SCCM to r3 and ive started monitoring the back-end with Red Gates SQL Monitor. Over the weekend ive got over 1k warnings about long queries. Is this normal with SCCM, There seem to be 2-5 queries that keep on getting repeated every few mins..
How does everyone like to deal with 3rd products. Cant change the query only your local box.
It this something i should learn to live with and move on?
thanks for any advice
Stephen

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Dealing with a third party is a tricky business. They might have a clause stating that if you do any change on the DB, they will not support the product. Some will allow you to add index. It is best to contact the 3rd party and tell them that you have performance issues. They MIGHT do something about it in the next build or something.

-Roy

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

stebennettsjb (10/17/2011)
Hi all,
We just upgraded SCCM to r3 and ive started monitoring the back-end with Red Gates SQL Monitor. Over the weekend ive got over 1k warnings about long queries. Is this normal with SCCM, There seem to be 2-5 queries that keep on getting repeated every few mins..
How does everyone like to deal with 3rd products. Cant change the query only your local box.
It this something i should learn to live with and move on?
thanks for any advice
Stephen

What did you define "long queries" as?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)