Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Long running queries and platform degredation - can I set a timeout?

Avatar

Avatar
Level 1
andrewm82075784
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
andrewm82075784
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
andrewm82075784
Level 1

09-05-2018

We have had a couple of issues with Adobe Campaign Manager where some of our less experienced users have built workflows that have basically generated a cartesian join which has resulted in them querying billions of rows of data. While some of this is down to lack of experience and learning curves, the resulting deterioration in performance is pretty extensive and basically can grind the platform to a halt.

Is there any way of guarding against this through a configuration setting that either (1) sets a limit on the maximum rows returned by a query or (2) via a timeout ?

We are running SQL Server as our campaign database but also use FDA into Red Shift.

Any suggestions would be much appreciated.

thanks

Andrew

Accepted Solutions (0)

Answers (0)