Yes I Have only one primary and one secondary .

What is witness ? is that share storage ?

Another Question ?

What is diference between "Automat Failover" And "Automat Redirection"

I Thin I found the Problem.

I dont have quorum

And whitout quorum , automatic failover dont happend.

yes ?

Because The cur Database has about 200 GB.

And we dont have enough space and we must Backup from it and then truncate tables.

But Backup from this size with many connections...

I read It.

the most important and repeatedly Advise is :

Dont use Repair option (If you have Backup). because ....

The impression from this recommendation can be

1- I must run...

Hi Again

I want to do some thing on this database.

First Of All , I should start with a small database.

But current DB has many connection from site. And I Should...

Because I read somewhere , PK and Clustered index, can be separate (These two do not necessarily Be one thing)

And it's better that clustered index related to Bussiness and...

I run this query on my database.

Most of the result are : PK_ ... ?

Why?

(note that in all our tables , we insert an id column - identical - that...

Automatic sync

TNX alot

Is very useful ideas and tips in your comments. (all of you)

Thanks alot

OK Thank you

I did not see link.

I use it Now.

Which search? (select from dmv's or select from taht table)

Then what is the best way to get Unused indexes?

Please say me more about :

"but that means you need to be prepared to deal with a lot of data. You should probably add the query_hash to your events...

CREATE TABLE [dbo].[...](

[Id] [bigint] IDENTITY(1,1) NOT NULL,

[SessionId] [bigint] NOT NULL,

[RegDate] [date] NOT NULL,

[RegTime] [time](0) NOT NULL,

[ReferrerUrl] [nvarchar](2000) NOT NULL,

[LandingUrl] [nvarchar](2000) NOT NULL,

CONSTRAINT [PK_TBL_Request_Id] PRIMARY KEY CLUSTERED

(

[Id] DESC

)WITH (PAD_INDEX...

No :blush:

I think I should Know more about these tools and performance Basics.

Thank you