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 |
|
ricky_newbee
Posting Yak Master
126 Posts |
 Posted - 2005-12-19 : 10:25:46
|
| How can i set User resource or session resource?My issue, i want to restrict a session/connection not to use full server resource. Is there any way to do so?Thanks,Rick |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-19 : 10:48:10
|
| Lookup "permissions-SQL Server" in Books On-line. |
 |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2005-12-19 : 11:09:03
|
| Dan, Thanks. But the Permission-SQL Server topic is talking all about Grants and Permissions. Guess my question wasnt clear.Here is what i need.I have daily jobs running, and business users connections. Job 1 runs about 3 hours. Job 1 is taking most of the resources. Is there any way to set Job1(User1) can user only 10% of resources. so, other can use rest of the server resources? I don't mind job running for 6 or 10 hours. Hope that helps.Thanks,Rick |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-20 : 09:11:47
|
quote:
Originally posted by ricky_newbee
Dan, Thanks. But the Permission-SQL Server topic is talking all about Grants and Permissions. Guess my question wasnt clear.Here is what i need.I have daily jobs running, and business users connections. Job 1 runs about 3 hours. Job 1 is taking most of the resources. Is there any way to set Job1(User1) can user only 10% of resources. so, other can use rest of the server resources? I don't mind job running for 6 or 10 hours. Hope that helps.Thanks,Rick
Maybe you can run your job in the off hours or try to tune it. The only thing I know of for jobs is a setting to start a job when the server is idle. |
|
|
|
|
|
|
User Resource