Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL as a service? How to manage abuse? Expand / Collapse
Author
Message
Posted Monday, July 14, 2014 9:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 9:22 PM
Points: 2, Visits: 3
Hello,

Consider a set of static data of which I want people to run their own queries against.

What methods might be available to prevent someone from either purposely (or accidentally) DOS'ing the server via some sort of bad command? ie - a ton of joins on virtual tables. Monitoring the resources of Python alone would not suffice, particularly if they have caused the mysql process to run away.

The data would actually be read-only and would not change.

Thank you.
Post #1592400
Posted Tuesday, July 15, 2014 1:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 2,532, Visits: 7,086
jumbojim22 (7/14/2014)
Hello,

Consider a set of static data of which I want people to run their own queries against.

What methods might be available to prevent someone from either purposely (or accidentally) DOS'ing the server via some sort of bad command? ie - a ton of joins on virtual tables. Monitoring the resources of Python alone would not suffice, particularly if they have caused the mysql process to run away.

The data would actually be read-only and would not change.

Thank you.


First things that come to mind are memory resident database and resource governance.
Post #1592425
Posted Tuesday, July 15, 2014 9:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 9:22 PM
Points: 2, Visits: 3
Can resources be limited per-user? Could this be realistically limited if a particular user abused resources?
Post #1592891
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse