January 31, 2018 at 8:52 am
I have a user who I granted with read only access to our DW and I wanted to know if there is a way to restrict resource consumption. I don't want her to use like cartesian joins or write bad query and use all the resources. I know this question is a bit silly but I am just trying to learn. We use SQL Server 2008 Standard edition.
January 31, 2018 at 9:11 am
I would think you could do this using the Resource Governor feature. Create a resource pool to limit the CPU usage for the login in question.
Please note, I have not used RG myself, so I'm not sure how much help I could be in configuring it.
January 31, 2018 at 10:26 am
jasona.work - Wednesday, January 31, 2018 9:11 AMI would think you could do this using the Resource Governor feature. Create a resource pool to limit the CPU usage for the login in question.Please note, I have not used RG myself, so I'm not sure how much help I could be in configuring it.
RG won't work in this case due to the limitation of the version of SQL Server I am on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply