Hi,

I have nothing on error log.

I think if I can restart SQL Engine on secondary node, it could be fix some issues. I tried to stop it but actually the...

Hi,

The cluster service on each Node is started.

Regards,

Eric

I executed on secondary the following command : ALTER DATABASE ZEPRA SET HADR OFF and get this error message.

Error: 35220, Severity: 16, Could not process the operation. AlwaysOn Availability Groups...

Hi,

The cluster rôle AO looks like good.

On the AO Dashboard, DI2097SW server (secondary) said replica is disconnected. When I connected to it, only one database is not synchronizing.

I don't understand...

Hi,

I tried to kill session but nothing happen. I still have the session up implicated (. I tried to reboot to IIS server (DI2032SW) but the session SPID 242...

Hi,

What do you mean by "recovering the secondary" ?

I have 80 databases on default instance only three of them are in "not synchronizing".

Regards,

Eric

Just to addind some informations.

I tried to restart SQL Engine and I can't stop it because there're some phantom's transactions (see picture).

I tried to kill them but nothing happen.

Thanks

Hi,

I have a question. I have a Filestream database with 1.8To of data (6900 files - 20Go for filestream). The restore database will take 17 Hours.

To improve the backup duration,...

Hi,

I changed WHERE Clause like you said and I have always index scan ?

Regards,

EC

I ran on NOYAU.patient a full Update Statistics but change nothing.

Query takes 1700ms all the time

Hi Lowell,

Thanks for your Help guy.

I know if you use a complicated view (it's a case), you can get a crappy plan. Another thing, on view you can't create indexes,...

Do you do Index Maintenance and index rebuilds ? Yes, I do just before issue.

Also see if you can find any missing indexes. No missing indexes

Is this 32 bit...

Hello mate,

No track :hehe:

Thanks,

Eric

Thanks

Msg 4512, Level 16, State 3, Procedure VUE_DOMINHO_NOYAU_sFichesIdAutresMetierTEST, Line 5

Cannot schema bind view 'forms.VUE_DOMINHO_NOYAU_sFichesIdAutresMetierTEST' because name 'NOYAU.PATIENT.PATIENT' is invalid for schema binding. Names must be in two-part format and an...