dba-one

Comments

  • We experience deadlocks daily on all database servers hosting SW databases and I get alerts emailed to me whenever they happen so I'm aware of all occurrences. I've been able to deal with a lot of this by tweaking indexes such as changing settings to not use page locks (luckily if haven't seen lock escalations to the table…
    in What we are working on post NPM 10.4 Comment by dba-one March 2013
  • Edit: The command is -NoTypeInformation Example: Get-SwisData $swis $query | Export-Csv C:\downloads\Testquery.csv -NoTypeInformation Any idea as to how to avoid the first line in the export to CSV? #TYPE PscxDynamicType3 "NodeID","Caption" "5","SWNPM.Blah" "6","SWNTA.Blah" "7","NPMSQL.Blah" "9","Blah"
    in Extracting Netflow 4.0 data Comment by dba-one September 2016
  • Zack, Thanks for getting back to me. I've managed to solve the problem, but I'm not altogether sure why something's work and others do not with the insert statement provided in your script. All map points appear on the map, but some nodes show no information. I went in to manage map and selected one of the problem node…
    in WorldMapResource_IMPORT.sql Comment by dba-one June 2014
  • Have you had any issues with some areas appearing on the map but with no information about the nodes? I've loaded a few records using a method based on the script. All node information shows up for one location but no node information for the other two. I've run a detailed trace on the SQL run on the back end and I can't…
    in WorldMapResource_IMPORT.sql Comment by dba-one June 2014
  • Some tables in SW have foreign keys so simply deleting from the table can be problematic.The statement to purge data from that table is very easy but as a newbie, I can't post it here. Lowering your retention settings is the best way to handle this issue because deleting from a given table can cause big issues. I can give…
    in How I can delete data from my database to free up space? Comment by dba-one June 2013
Avatar