hi

in case of Managed Instance (Azure SQL DB) you have no control over the underlying instance.

All you can do is to get understanding how big tempdb can be according to...

the query store is a useful tool, but as soon as your proc cache changes or you reboot your server then you start losing all of the valuable information...

to check whether a member of deleted group still has access to the SQL server, run the following:

exec xp_logininfo 'DOMAIN\user','all'

most probably, if it does have, then it...

• This reply was modified 5 years, 1 month ago by  Andrey. Reason: added xp_enumgroups

btw, you can check procedure cache using the following query:

 select objtype [objtype]
, cacheobjtype
, sum(1) [plans]
, convert(numeric(10,1),sum(size_in_bytes/1024.)/1024.) [TotalSizeMB]
, max(size_in_bytes)/1024/1024 [LargestPlan_MB] 
from sys.dm_exec_cached_plans 
group by objtype, cacheobjtype
order by...

Sys.dm_os_ring_buffers DMV can be used to troubleshoot connectivity errors, track exceptions, monitor system health, memory pressure, Non-yielding/Deadlocked schedulers and a lot more.

It means that the most content there relates to...

Another options is a big query with huge execution plan which pushes other plans away from proc cache.

I saw similar issue with single exec plan 400MB+ in size.

Enable QueryStore on...

I suspect Express Edition  and/or  option AutoClose=on of your DB

• This reply was modified 5 years, 1 month ago by  Andrey. Reason: and -> and/or

In our case, when I try to connect using kevin user from windows machine, where SSMS is installed , I don't see any issues. Which means there is no...

I would also check ring_buffer  & default trace for login failed events

RING_BUFFER

https://www.johnsansom.com/using-sys-dm_os_ring_buffers-troubleshoot-connectivity-issues/

Default trace:

SELECT TOP 100 te.name
,ft.SPID
,ft.LoginName
,ft.Hostname
,ft.ClientProcessID
,ft.DatabaseName
--,ft.FileName
,ft.StartTime
,dateadd(ms, ft.Duration / 1000, ft.StartTime) [FinishTime]
,ft.ApplicationName
--,ft.ObjectID
--,ft.Duration / 1000 / 1000 [Duration...

hi Pat!

I'm not sure what the desired design should be , but you can try Rectangle - put both tables inside and they should be kept together.

I think it's logical to check using t-sql things that look weird in ssms.

I don't get why people post here questions which a easily googable.

get list of available languages :

exec sp_helplanguage

alter login with default language :

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-defaultlanguage-transact-sql

SSMS is a GUI and does have bugs

so, it's better to use commands and procedures

drop down of what?

what application do you use?

select name,type_desc,default_language_name,default_database_name from sys.server_principals  where type not in ('R','C')

run this query and get the logins with their  default languages

Are they visible in "Instance->Security->Logins" ?