PerfMon: Using SQL Server Performance Counters

  • Comments posted to this topic are about the item PerfMon: Using SQL Server Performance Counters

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • Hi Kenneth, I tried following your talk, my sql is 2016, I chose the sql template when I hit finish Powershell opens then it errors I see text in red lines then disappears. Does PAL record errors somewhere in a file?

    Thanks

  • eliassal wrote:

    Hi Kenneth, I tried following your talk, my sql is 2016, I chose the sql template when I hit finish Powershell opens then it errors I see text in red lines then disappears. Does PAL record errors somewhere in a file?

    Thanks

    Hi Eliassal. Unfortunately I haven't seen that in PAL.

    But the PAL programme does something like invoking a batch script that runs a PowerShell commandlet. So it may be possible to catch the errors by using techniques for catching PowerShell errors. I haven't done this though. Here is my batch script:

    start /LOW /WAIT Powershell -ExecutionPolicy ByPass -NoProfile -File ".\PAL.ps1" -Log "C:\PerfLogs\Admin\SQL Server DCS\IGIRI01_20220702-000001\DataCollector01.blg" -ThresholdFile "C:\Program Files\PAL\PAL\SystemOverview.xml" -Interval "AUTO" -IsOutputHtml $True -HtmlOutputFileName "[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].htm" -IsOutputXml $False -XmlOutputFileName "[LogFileName]_PAL_ANALYSIS_[DateTimeStamp].xml" -AllCounterStats $False -OutputDir "C:\PAL Reports" -NumberOfThreads 4 -IsLowPriority $True -OS "Windows Server" -PhysicalMemory "16" -UserVa "2048"

    You could explore this by replace the arguments with yours.

     

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply