Jack Corbett Thank you for reply..

identifying indexes that may be candidates for dropping or modification? user_update values modified frequently.

Identified that NC INDEX on table,

SP inside, there is one SELECT complex...

Hi,

I checked unused index, As per that script result return value only two column in NONCLUSTERED

total 4 NONCLUSTERED index values as below and Remaining all the column...

it is not SSRS, another application such as aspx.

SQLRNNR (2/26/2014)

---

Is there a time of day that they run slow all the time?

There is no fixed time period, whenever user tried generated reports time running fast & slow, I...

First Error resolved Just refersh that View at source server, then fetch 198768 rows from source database thru linked server..

But i am facing another memory issues while executing that linked...

I will try to tuning that blocking query.

I have configured TEMPDB at initial stage and different location, not in user database files location, Also configured MAXDOP and cost of threshold...

Thanks Gila, as you suggested no need to assign the NOLOCK hint at statement level, it cause of incorrect data will be display in reporting.

Yes. Second one is another blocking...

Due to blcoking another statement, so that query was taking too much duration. maunally executed in SSMS also took 30 min during the blocking happening. attached Actual exe.plan for blocking...

I am checking with profiler, this paricualr Query tooks duration 30 sec for completion at every execution, and CPU is 0 seconds..

I tried as below script and executed with no errors for result in create text file but File is not created in C drive. Pls suggestion me

Create table #Results (

TotalPhysicalMemory_MB...

Thanks .. So SQL instance could used 8 GB max memory .. just i want to know, is the normal usages?

For the best system, It should Target memory should be...

if any impact of tlog backup on mirror database in prinicpal server? is the any issues logs truncated by tlog backup in principal database. so how truncated data will apply...

Resolved CPU issues after changing few steps, now CPU usages 12 %

1. Adding missing index some tables which are not created before nonclustered index

2. Changed the default setting cost threshold...

Query is not a problem also facing any performance issues from user side but CPU always utilize 60 % constantly.

why index scan cost always 90% at every exectuion? please suggestion...

I checked that article, it should be UNSAFE Access in CLR object then only external resource will be used, so SAFE access not possible to set the CLR object.. But...