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.
| 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. |
 |
|
|
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? |
|
|
|
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 |
|
|
|
|
|
|
SQL as a service? How to manage abuse?