if query is running long time to excute how to resolve?


if query  is running long time  to excute how  to  resolve? 

hi venkat,

there many reasons why query running long time, might normal. before answer questions, please tell query , how environment such cpu , ram utilization.

the following articles may helpful you, see: troubleshooting performance problems in sql server 2005.

regards,
chunsong


please remember mark replies answers if , unmark them if provide no help.


SQL Server  >  SQL Server Database Engine



Comments

Popular posts from this blog

BIT Version

Admin Permissions

Problems installing SQL Server 2014 - There was a failure to calculate the applicability of setting LICENSEPATH.