Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 SQL as a service? How to manage abuse?

Author  Topic 

jumbojim22
Starting Member

2 Posts

Posted - 2014-07-14 : 23:45:02
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.

MichaelJSQL
Constraint Violating Yak Guru

252 Posts

Posted - 2014-07-15 : 07:34:25
If you are on a 2008 server with 2008 SQL Server or above you can us the resource governor.
Go to Top of Page

jumbojim22
Starting Member

2 Posts

Posted - 2014-07-15 : 23:21:26
This can be done via per-user? Could this be realistically limited if a particular user abused resources?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-16 : 04:05:37
This is a Microsoft SQL Server forum. If you are asking for MySQL, try over at www.dbforums.com


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -