If you are also trying to run XMS.Net application and want to subscribe to some topic with selector string to filter messages, remember to run the application in 'unmanaged' mode.
It is important to create good indexes so that your queries do not unnecessarily need to scan many rows, that can result in lock on those rows and due to which deadlocks can occur, performance can be degraded, or anything bad can happen.