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  SQL Server 2008 Forums  SQL Server Administration (2008)  Issues with deleting Resource governor/ classifier

Author  Topic  thirulok Starting Member 1 Post Posted - 2011-05-27 : 16:43:16 Hi i created a classifier function based on login name. There is a resource pool which I have created and a workload group associated to it. now i wanted to add some more logins in the function. I tried to drop the function and create a new function. But i couldn't delete, i got an error that the classifier function is being used by resource governor. so i came to resource governor and tried to remove the workload group and the resource pool, i was able to do it but also got a message Resource governor configuration failed. "There are active sessions in workload groups being dropped or moved to different resource pools. Disconnect all active sessions in the affected workload groups and try again." i disabled the resource governor, but still unable to do any thing, it wouldn't let me reconfigure. throws the same message above. any help is greatly appreciated!!