If your concerned your SQL server database is the cause of a performance issue then these commands might help
Tag: Long Running Transactions
Troubleshooting Postgres Performance
IF you think postgres performance is the cause of an application performing badly these sql statements may help