This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var clientSettings = new MongoClientSettings(); | |
var traceSource = new TraceSource("MongoDB-CMAP-SDAM", SourceLevels.All); | |
traceSource.Listeners.Clear(); // remove the default listener | |
var logFileName = "<should be updated on the real path to a log file>"; | |
var listener = new TextWriterTraceListener(new FileStream(logFileName, FileMode.Append)); | |
listener.TraceOutputOptions = TraceOptions.DateTime; | |
traceSource.Listeners.Add(listener); | |
var eventSubscriber = new TraceSourceEventSubscriber(traceSource); | |
Action<ClusterBuilder> clusterConfigurator = builder => builder.Subscribe(eventSubscriber); // if you don't use a MongoClient as singletone, it's better to share the same instance(so object.ReferenceEquals for them should return true) of this configurator, between all mongo clients | |
clientSettings.ClusterConfigurator = clusterConfigurator; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
while($true) { cls ; '' ; ps | sort cpu -Descending | select -first 20 | ft -auto; Start-Sleep -Milliseconds 1000 } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"background": "#1B1D1E", | |
"black": "#222D3F", | |
"blue": "#3167AC", | |
"brightBlack": "#a4eeb7", | |
"brightBlue": "#3C7DD2", | |
"brightCyan": "#35B387", | |
"brightGreen": "#2D9440", | |
"brightPurple": "#8230A7", | |
"brightRed": "#D4312E", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# If $value is not $null or 0 or $false or an empty string | |
if ($null -ne $value -and $value -ne 0 -and $value -ne '' -and $value -ne $false ){ | |
:do | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @session_id INT, @sql NVARCHAR (4000); | |
DECLARE database_curs CURSOR FAST_FORWARD FOR | |
SELECT c.session_id | |
FROM sys.dm_exec_connections AS c | |
JOIN sys.dm_exec_sessions AS s ON c.session_id = s.session_id | |
WHERE c.session_id <> @@SPID AND s.is_user_process = 1; | |
OPEN database_curs; | |
FETCH NEXT FROM database_curs INTO @session_id; | |
WHILE (@@fetch_status <> -1) | |
BEGIN |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
;WITH StatTables AS( | |
SELECT so.schema_id AS 'schema_id', so.name AS 'TableName', so.object_id AS 'object_id', ISNULL(sp.rows,0) AS 'ApproximateRows', ISNULL(sp.modification_counter,0) AS 'RowModCtr' | |
FROM sys.objects so (NOLOCK) JOIN sys.stats st (NOLOCK) ON so.object_id=st.object_id | |
CROSS APPLY sys.dm_db_stats_properties(so.object_id, st.stats_id) AS sp | |
WHERE so.is_ms_shipped = 0 AND st.stats_id<>0 | |
AND so.object_id NOT IN (SELECT major_id FROM sys.extended_properties (NOLOCK) WHERE name = N'microsoft_database_tools_support') | |
), | |
StatTableGrouped AS( | |
SELECT ROW_NUMBER() OVER(ORDER BY TableName) AS seq1, ROW_NUMBER() OVER(ORDER BY TableName DESC) AS seq2, TableName, cast(Max(ApproximateRows) AS bigint) AS ApproximateRows, | |
cast(Max(RowModCtr) AS bigint) AS RowModCtr, count(*) AS StatCount, schema_id,object_id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ipAddress= "192.168.1.54" | |
[System.Net.Dns]::GetHostByAddress($ipAddress).Hostname |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT DB_NAME(database_id) DatabaseName, | |
OBJECT_NAME(object_id) ProcedureName, | |
cached_time, last_execution_time, execution_count, | |
total_elapsed_time/execution_count AS avg_elapsed_time, | |
type_desc, datetime=getdate() | |
FROM sys.dm_exec_procedure_stats | |
where database_id=6 | |
and OBJECT_NAME(object_id)='ProcExtendedSessionUpsertV5' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
;WITH RingBufferConnectivity as | |
( SELECT | |
records.record.value('(/Record/@id)[1]', 'int') AS [RecordID], | |
records.record.value('(/Record/ConnectivityTraceRecord/RecordType)[1]', 'varchar(max)') AS [RecordType], | |
records.record.value('(/Record/ConnectivityTraceRecord/RecordTime)[1]', 'datetime') AS [RecordTime], | |
records.record.value('(/Record/ConnectivityTraceRecord/SniConsumerError)[1]', 'int') AS [Error], | |
records.record.value('(/Record/ConnectivityTraceRecord/State)[1]', 'int') AS [State], | |
records.record.value('(/Record/ConnectivityTraceRecord/Spid)[1]', 'int') AS [Spid], | |
records.record.value('(/Record/ConnectivityTraceRecord/RemoteHost)[1]', 'varchar(max)') AS [RemoteHost], | |
records.record.value('(/Record/ConnectivityTraceRecord/RemotePort)[1]', 'varchar(max)') AS [RemotePort], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
try{ | |
Get-Childitem c:\Foo -ErrorAction stop | |
} | |
catch [System.Management.Automation.ItemNotFoundException]{ | |
'oops, I guess that folder was not there' | |
} |
NewerOlder