I found my solution for the resource governor

this is an example of my classifier funcfion

create function [dbo].[UDFClassifier]()

returns sysname

with schemabinding

as

begin

declare

@WorkloadGroup sysname,

@local_net_address varchar(48)

select @local_net_address = CAST(ConnectionProperty('local_net_address') as varchar(48))

if @local_net_address = 'XX.XX.XX.XX'

set @WorkloadGroup...

Thank you Leo, this is exactly what I want but now I have a problem to use this in my case.

I want to use the dns_name to configure the reresourceovernor...

I have thrown a look at the link, but I cant find my answer.

I give an exemple :

2 instances : mssql1, mssql2

2 DB : db1, db2

2 AG : ag1 with...

Thank you, but this system view displays a list of all listeners groups and not only one in which I made my connection.

Yes, the object already exists.

the problem is that someone has accidentally uncheck an article and when it have been recheck we lost indexes.

So it's why I want to automize the...

It's exactly what i mean!!

I want to keep the indexes on the subscriber when I adds a table to a publication.

So I wrote a script that create all indexes (script...

ok ... I planned a restart

thx for all

I want to shrink tempdb but I have a message

.I cant restart the instance.

I tried...

Arfff !!! :doze:

Thx, but this is not the answer that I was hoping

Does the value after the '_' represents something (in the name in tempdb.sys.objects)

Thank Drew, it works

There is an error in [CDCDemo].[dbo].[spgGetCDCContract]

replace

SET @from_lsn = sys.fn_cdc_map_time_to_lsn('largest greater than', @FromLSNDate);

by

SET @from_lsn = sys.fn_cdc_map_time_to_lsn('smallest greater than', @FromLSNDate);

I want to know for one index, knowing the page_count, the avg_fragmentation, the number of rows ...

Hello,

thank you for these answers.

The initial problem is that the backup takes 18 minutes while the restore takes 50 minutes.

Why so much difference?

Thx

The maintplan is already created directly on the server, I tried by creating another maintplan and it changes nothing.

I even tried by starting the services in Local System and nothing...

Hi,

MeltonDBA : it's a 32-bit server.

OomBoom : sa is the owner of the maint plan and the job.

free_mascot : I tested at various hours and the problem is not that...