• Is there a DBA that can help you with this? You probably shouldn't be the one deploying this index if you don't know how to get blocking or wait types information. I'm not saying that to be rude or mean, but thats pretty basic trouble shooting and you could be killing the client environment and not know it.