No. There is no separate filegroup for filestream.

I apparently had the wrong filename when I tried the diff the next time. It failed saying it couldn't find the filename. I corrected that and tried again and then...

What would be the problem with giving the application the IP address associated with the Availability Group Listener? If this would be a multi-subnet AG, you could update the application...

This is a query that is created by the application. I didn't write this. I know not to tie the hands of the query optimizer. I will go back to...

In my experience, this error is most commonly caused by a missing SPN. A PowerShell module called DBATools has a wealth of SQL Server related commands, some of which identify...

Have you tried using T-SQL and not the wizard?

ALTER AVAILABILITY GROUP MyAG ADD REPLICA ON 'COMPUTER04'

WITH (

ENDPOINT_URL = 'TCP://COMPUTER04.Adventure-Works.com:5022',

AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT,

FAILOVER_MODE = MANUAL

);

SQL Server Developer Edition is free and it has all the features of Enterprise Edition. You just can't use it as a back-end for a customer facing product. If you're...

I'll leave you with one link as your answer. In the long term, look into using Ola Hallengren's Maintenance Solution. I would also strongly encourage you...

Key lookups against a Primary Key clustered index happen when an existing non-clustered index doesn't have all the columns needed to "cover" the columns that need to be retrieved to...

You may want to consider backing off the index rebuilds. Fragmentation isn't typically the cause of a performance problem, but out of date statistics can be. I would encourage you...

Christi1711,

CXPacket waits are often normal and, by themselves do not indicate a problem. Handling deadlocks is a vast subject.

I would suggest investigating the use of a more optimistic isolation level...

Have you had a look at this? You can use the metrics on this page to create a formula to show you redo latency.

https://documentation.red-gate.com/sm9/analysis-graph/list-of-metrics

This also has some queries and...

Jeff is correct that there is no point in updating statistics after an index was rebuilt because rebuilding the index includes updating the statistics. sp_updatestats is a wrapper procedure for...

I am not familiar with any restrictions on features for SQL Server in Amazon RDS so I don't know if you have access to the SQL Server Agent in Amazon...

• This reply was modified 3 years, 11 months ago by  lmarkum.
• This reply was modified 3 years, 11 months ago by  lmarkum.

Glenn Berry's scripts are also another diagnostic tool for this scenario as Michael is suggesting. You will need to know which specific queries to run to find the problem though...