you will need this index on the dbo.Transaction

CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME] ON [dbo].[Transaction]

(

[InvoiceUID] ASC,

[IsSuccess] ASC,

[TransKind] ASC,

[TransactionDate] ASC

)

INCLUDE ( [CardNumber],[ReferenceNumber],[SeqCounter],[UnqReferenceNumber]);

and this index for the dbo.Invoice

CREATE UNIQUE NONCLUSTERED INDEX [INDEX_NAME]...

Thank you a lot for your attention and reply .

But the cost of index seek for IX_Invoice is 1% and the logical reads for Invoice table is just 14286.

Table 'Transaction'....

I created the filtered covering index on InvoiceUID as you said,(run dbcc freeproccache and dbcc dropcleanbuffers) but it was not usable.Again it uses the IX_invoice index and the plan...

But the Invoiceuid is PK and has a clustered index in dbo.Invoice table.

ALTER TABLE [dbo].[Invoice]

ADD CONSTRAINT [PK_Invoice] PRIMARY KEY CLUSTERED([InvoiceUID] ASC)

Currently the index is just on invoiceuid,but because of lookup I test it with other columns too.But for both modes the logical io is high.

I am so sorry,I asked my question in a wrong way.Yes I know that we have problem in one of our queries,and I am involved.(The logical io is too...

Thanks a lot 🙂

So how long does the principal wait for the message from the mirror server?Can I manually decrease that time?

RVSC48 (9/28/2016)

---

High Safety Mode -

After synchronization finishes, every transaction committed on the principal database is also committed on the mirror server, guaranteeing protection of the data. This is achieved...

For both mdf and ldf disk ,64k works best?

You mean,the time out is because fragmentation on that index?

What about catalog size?Does is have any effect on it?

What is catalog size and what happen when we rebuild it?

This is the output:

ErrorLogIX_ErrorLogFNNONCLUSTERED INDEX91.3237076278522144405

ErrorLogPK_LogCLUSTERED INDEX1.377094313331011301799

*and in addition the timeout occurs some times,may be we do not have it for 2 days.

There is just insert and select on this table .It has a clustered Index on bigint field.and one non_unique_clustered.

CREATE NONCLUSTERED INDEX [IX_ErrorLogFN] ON [dbo].[ErrorLog]

(

[ParentLogId] ASC,

[ActionDate] ASC,

[TermID] ASC,

[MerchID] ASC,

[ActivityType] ASC

)

The...

Thank you for simplifying the calculation,so as he said if a server has 64 GB of RAM, and the Windows operating system is Windows Server 2008 64-bit Standard Edition, then...

Thanks for your help

but I am so confused about the setting the max server memory for SQL with the right value.

I read the Memory Management chapter of Jonathan Kehayias ebook:

"if...