bazz

Comments

  • I am a DBA and I endorse this message. Over the last 20 years or so I've found that a good starting point is 75%. Assuming that there is only 1 SQL Instance and nothing else apart from Anti-virus (You did ask your server guys to exlude MDF, LDF, NFD, BAK and TRN files from scanning, right?). 75% of server memory. Then add…
    in Killing the “SQL Server is a Memory Hog” Myth Comment by bazz June 2017
  • Was just about to post this very idea.
    in AppInsight for SQL ignore indexes below XXX pages threshold Comment by bazz September 2013
  • Can you tell me what level of access I need to be able to select SQL rather than WSQL in the report editor? (I'm a DBA not completely familier with Orion backend) At the moment I can only select WSQL.
    in How to Create SQL alerts reports in web based Comment by bazz January 2019
  • Cheers.. I think that's got it. In factt he filed DB_Server appears in both Nodes and NodesCustomProperties tables whichis what confused me.
    in Filtering Application view Comment by bazz July 2016
  • Whenever I try and add this script into the report editor is tells me the query is invalid. Any advice? Orion Platform 2018.2 HF6, IPAM 4.7.0, VNQM 4.5.0, NPM 12.3, DPAIM 11.1.0, PM 2.1, NTA 4.2.3, VMAN 8.3.0, SAM 6.7.0, NetPath 1.1.3
    in Current Muted Alerts (v5) [SAM & NPM] Comment by bazz January 2019
  • Thanks for all the replies... I'm slowly getting it, I think. The Server itself has 32G ram installed. The SQL Server is capped at 16gb because there is SSRS and SSAS also running and 16Gb was deemed enough after a couple of weeks operating. It rarely actually consumed 16Gb for the SQL Server Service. So as I undertand it,…
    in Total and Target server memory Comment by bazz February 2017
Avatar