Sorry I think I found the cause and the solution :

https://support.microsoft.com/en-us/kb/2761129

A hotfix for windows 2008 r2

But I worry about install it on operational server.

Thank you

But

Can I diagnose which transaction had been run?

OR in other word , Can I read the log part from this full backup and find the "Long open...

No , The opposite . I expected see the execution count on the ascending Order.

It means every day should be more than prev day. Because value of execution count...

Hi

Thanks a lot

I Read cached_time field beside another fields. The result was frustrated. :crying:

These are the result for one stored procedure :

execution_count--- SelectTime ----------------- - cached_time

96344----------- - 2016-05-01...

No

I checked all jobs, SPs and functions . I didnt find any thing that envolves FREEPROCCACHE or SP_Configure .

I think something unpleasant occurred. For example a sort of...

No it isn't. we don't have clustering.

is it possible someone is downing the...

Another question (If possible) :

Befor Partitioning I saved some result for some query on this table. (Logical reads and ...)

After partitioning

- logical read has incredibly...

excuse me !!

I review execution plan percisly .

It used index (seek , ...)

But show the suggest that index again .

CREATE NONCLUSTERED INDEX [IDX_Nonc_TaxCode] ON [dbo].[Table1]

(

[TaxCode] ASC

)WITH (PAD_INDEX =...

Thank you all

And dear Lynn Pettis :

The big question here, is this something your employer is tasking you to accomplish or are you just trying to find a way to...

hi again

Thank you "Grant Fritchey"

But I encounter with some limitations:

1- our main server is on the internet and local server obviously is on local network. Then After all tasks...

Thank you for your attention . 🙂

and these are the data which you wanted :

scheduler_idcpu_idstatus

00VISIBLE ONLINE

11VISIBLE ONLINE

22VISIBLE ONLINE

33VISIBLE ONLINE

44VISIBLE ONLINE

55VISIBLE ONLINE

66VISIBLE ONLINE

77VISIBLE ONLINE

88VISIBLE ONLINE

99VISIBLE ONLINE

1010VISIBLE ONLINE

1111VISIBLE ONLINE

1212VISIBLE ONLINE

1313VISIBLE ONLINE

1414VISIBLE...

Microsoft SQL Server 2014 - 12.0.4100.1 (X64)

Apr 20 2015 17:29:27

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

DECLARE @x xml = '<main>

<purch id="14" a="0">

<item id="449" a="0" />

<item id="450" a="0" />

<Something />

</purch>

<invo>

<Volvo12 vid="24549" />

<Volvo43 vid="88357" />

<Something />

</invo>

</main>';

But If @x will be a field in a table and I...

The result Exactly is True

Thank you

😛

I tried to connect with it from odbc .

But after install (informix client tools 4.10.TC 6), I can not see informix driver in our list of drivers for odbc...