Hy,

sorry, but I don't understand your question.

The sql server is able to handle a lot of connetions in the same time.

It only depends on your database, the query and a...

Hi,

we got this error sometimes, and we don't care about it.

I think, the error occours, if the AD controller, the sql server is connect, is in maintenance, and the next...

Good morning,

thanks for your answers and your thoughts. I will change the check in sql monitor, so I will not get a warning with an index < 2.000 pages.

So nobody...

Hello Jeff,

I check the fragmentation with this script, I found some years ago in the internet:

SELECT 
dbschemas.[name] as 'Schema',
dbtables.[name] as 'Table',
dbindexes.[name] as 'Index',
indexstats.avg_fragmentation_in_percent,
indexstats.page_count
FROM 
sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL,...

Good morning,

I am able to rebuild this index. And thats the problem, when I could rebuild the index, why wouldn't the Ola script rebuild the index?

I thinks, this is just...

Hi,

after you restored the database on the new sql server 2019, you may change the compatibility level to 2019.

Otherwise you may not use all the new features from 2019.

On the...

Hi,

is the SSMS on the same server like the sql server?

And what kind of protocols are active on the sql server?

Hi,

thanks for your post, you safed my day, maybe my whole life.

It works, and now I am able to support my team.

Thanks a lot,

Kind regards,

Andreas

Hi,

you can check why your logfile won't be "free" inside:

SELECT
    name AS DatabaseName,
    log_reuse_wait_desc AS LogBlocking,
    recovery_model_desc AS...

Hi,

you can try a Job with 2 steps.

1. step will check is sql server is the primary part of the aoag
2. step will only execute if the sql server is...

Hm,

the message I/O frozen, I only can remember this message from snapshot backup of the sql server.

If we use regular backup, I've never seen this message before. And we got...

Hi,

what kind of backup do you use?

Maintenance Plans or regular jobs?

Are there some steps in your job, or only one backup step?

I think, we need more information to help you.

Kind...

Hi,

just download the developer edition and learn to play with sql server.

There are a lot of good internet pages, where you can learn to be a good developer.

Nobody knows what...

Hi

have you ever testet a execute as the normal user in the same SPID from the sysadmin?

• open a new query from sysadmin
• and run this query:

EXECUTE...

Hi,

I think you created the job via maintenance plans?

I did this on my test environment, and I got the same error.

I changed the job owner to sa, and now the...