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.
| Author |
Topic |
|
Elvira
Starting Member
4 Posts |
 Posted - 2010-11-22 : 02:32:30
|
| I am using SQL Server 2008. There is such a query:"Select * from t1 where dWhen < DATEADD (dd ,-90,GETDATE())".When I open Activity Monitor I can see that very old queries still in the "Recent Expensive Queries". For example: "select DATEADD (dd ,-90,GETDATE())" returns "2010-08-24 08:00:31.283" and in "Recent Expensive Queries" I can see query: "Select * from t1 where dWhen < 'Aug 21 2010 10:56AM'". After restarting the server old queries have disappeared.Can someone, please, suggest me why it happens and how I can fix the problem without restarting the Server? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-22 : 08:20:15
|
| nothing is broken. you restarted the server which dumped the cache, reset DMVs |
 |
|
|
|
|
|
Cashed queries.