Questions tagged [sp-askbrent]

sp_AskBrent is a SQL Server stored procedure offered by Brent Ozar - questions with this tag should be about how to use sp_AskBrent

Filter by
Sorted by
Tagged with
-1
votes
1answer
79 views

Should I place Kimball Data Warehouse in Microsoft Columnstore Index on Premise?

Are Columnstore tables now the vendor default method for Kimball Data warehouse tables with Dim and Facts for On Premise? I know in the cloud, Microsoft automaticaly recommends Azure Data warehouses ...
4
votes
1answer
978 views

Trace flag 8048

My DB is running on SQL 2012 and we have 32 core processors. As per SP_Blitz (Brent Ozar) we need to enable Trace flag 8048. My question is should we enable this flag on 2012 or it is recommended only ...
0
votes
1answer
194 views

sp_BlitzFirst fails when outputting values to tables

I have had an agent job running sp_AskBrent for some time, running with the following parameters: EXEC sp_AskBrent @Expertmode=1 ,@OutputDatabaseName = 'DBName' , @OutputSchemaName = 'dbo' , @...
1
vote
1answer
201 views

sp_AskBrent not logging queries when saving to table vs. sp_WhoIsActive

sp_AskBrent, when run as an agent job every 5 minutes is logging to a table but never seems to populate QueryText. However, sp_WhoIsActive, when also run every 5 minutes on the same SQL Server ...
1
vote
1answer
386 views

First Response Kit is missing sp_AskBrent

I just downloaded the First Responder kit. Unfortunately, the 'sp_AskBrent' was not included in the download. How can I get it to complete the kit?
11
votes
1answer
408 views

How to export the output of sp_AskBrent?

We have an instance that randomly spikes the CPU. I want to create an alert that fires on CPU over 90% and automatically calls a job that runs sp_AskBrent and emails me the output. However, the output ...
6
votes
2answers
942 views

Running sp_AskBrent with @ExpertMode = 1 in PowerShell

I am trying to run sp_AskBrent from PowerShell using Invoke-SQLCmd and capture its output in a variable: $query = "EXEC SAIDBA.monitoring.sp_AskBrent @Seconds=10;" $check = Invoke-Sqlcmd -...