阅读背景:

在SQL Server 2005中拦截和重写查询

来源:互联网 

We have an application built on top of SQL server 2005 that we have no control over. We've recently discovered that this application is sending some very inefficient SELECT queries to SQL that is causing serious capacity issues on the database. I know the right solution is to crack open the code for the application and change the queries, but for reasons I won't go into that's going to take a very long time. Is there some way we can intercept this specific query on SQL server and selectively re-write it to something more optimal? We have an application built on top of SQL serv




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: