Viewing 15 posts - 16 through 30 (of 247 total)
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...
November 6, 2019 at 11:13 am
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...
October 17, 2019 at 3:16 pm
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...
October 16, 2019 at 3:09 pm
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...
October 16, 2019 at 2:51 pm
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...
October 16, 2019 at 2:46 pm
I suspect Express Edition and/or option AutoClose=on of your DB
October 16, 2019 at 1:41 pm
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...
October 16, 2019 at 1:36 pm
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...
October 16, 2019 at 11:52 am
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.
October 10, 2019 at 8:36 am
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.
September 27, 2019 at 5:44 pm
get list of available languages :
exec sp_helplanguage
alter login with default language :
SSMS is a GUI and does have bugs
so, it's better to use commands and procedures
September 26, 2019 at 3:59 pm
And British English is not even on the drop down.
drop down of what?
what application do you use?
September 26, 2019 at 2:56 pm
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
September 26, 2019 at 2:54 pm
Are they visible in "Instance->Security->Logins" ?
September 26, 2019 at 8:36 am
hi Sam
check best practices for SSISDB first
https://www.mssqltips.com/sqlservertip/4811/sql-server-integration-services-catalog-best-practices/
better purge job
https://www.timmitchell.net/post/2018/12/30/a-better-way-to-clean-up-the-ssis-catalog-database/
It is possible to move SSISDB like other databases.
September 26, 2019 at 8:31 am
Viewing 15 posts - 16 through 30 (of 247 total)