Chapter23:ManagingtheOrionDatabase
Note:ThePropertiestabincludesgeneralstatisticsrelatingtotheselected
tablesizeandcreationdate.TheColumnstablistskeys,columnnames,
sizeanddatatypesintheselectedtable.TheIndexestabshowsindexes
usedinthetable.
5. Toexecuteaquery,right-clickonthetablename,andthenclickQuery
Table.TheSQLquerydisplayedliststhecontentsofthetable.Users
familiarwithwritingSQLqueriescaneditthisqueryasrequired.Click
Executetorunthisquery.
6. Toeditthedatawithinatable:
a. Right-clickonthetablename,andclickQueryTable.
b. ClickExecutetorunthequery,whichliststhecontentsofthetablein
theResultspage.
c. ClickEnabletableediting.Youcannoweditthedatafieldswithinthe
tableasrequired.
Warning!Tableeditingshouldonlybeperformedbyadatabase
administratororotherexpertuser.Changesmadeherecan
jeopardizetheintegrityofyourdata.Itisrecommendedthatyou
usetheSettingswithyourOrionWebConsoletomakeany
necessarychangestodatabasesettingsandvalues.
7. Toexportatable,right-clickonthetablename,andclickExporttoCSV.
Youwillbeaskedtoenteranameforthecommaseparatedvaluefile
created.
651
Pdf data extraction open source - extract form data from PDF in C#.net, ASP.NET, MVC, Ajax, WPF
Help to Read and Extract Field Data from PDF with a Convenient C# Solution
extract data from pdf into excel; how to extract data from pdf to excel
Pdf data extraction open source - VB.NET PDF Form Data Read library: extract form data from PDF in vb.net, ASP.NET, MVC, Ajax, WPF
Convenient VB.NET Solution to Read and Extract Field Data from PDF
exporting data from pdf to excel; extract data from pdf to excel online
DatabaseMaintenance
TheprimarytasksinvolvedinmaintainingyourSolarWindsdatabasearedata
summarizationanddatabasecompaction.Datasummarizationoccurs
automaticallyasaregularpartoftheautomatedmaintenanceprogram.However,
youcanalsorundatabasemaintenanceasrequiredfromtheWindowsStart
menu.
RunningDatabaseMaintenance
Databasemaintenanceconsistsofaseriesofdatasummarizationstooptimize
thesizeofyourOriondatabase.Datasummarizationgathersthecollected
networkdataforadefinedperiod,calculatesstatisticsfromthedata,andthen
discardsthedataitselfwhileretainingthestatistics.
Databasemaintenanceisrunautomaticallyeverydayataspecifiedtime.
TospecifywhenDataMaintenanceisrun:
1. FromtheOrionWebConsole,clickSettings,and thenclickonPolling
SettingsintheThresholdsandPollingsection.
2. ScrolldowntotheDatabaseSettingssection,andenterthetimeyouwant
DataMaintenancetotakeplaceintheArchiveTimefield.
TolaunchDataMaintenancemanually:
1. ClickStart >AllPrograms >SolarWindsOrion >AdvancedFeatures >
DatabaseMaintenance.
2. ClickStart.
Note:AdministrativeprivilegesarerequiredtorunDatabaseMaintenance.
652
DatabaseMaintenance
C# PDF Text Extract Library: extract text content from PDF file in
using RasterEdge.XDoc.PDF; Please have a quick test by using the following C# example code for text extraction from PDF page. // Open a document.
filling out pdf forms with reader; extract data out of pdf file
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
Except provides PDF page extraction method in VB.NET, this page also gives VB This VB.NET code below can help you extract all images from PDF. ' Open a document
extract pdf data to excel; fill in pdf form reader
Chapter23:ManagingtheOrionDatabase
Best PracticesforManaging YourOrion Database
AsyourSQLdatabasematures,orafteraddingnewOrionproducts,your
databasemaybecomelargerthanyouoriginallyestimatedormightslow
unexpectedly.Severalfactorsmaycausetheseissues.Thissectionexploresthe
mostcommonissuesandexplainshowtocorrecttheissues.
ManagingDatabaseGrowthintheOrionWebInterface
ThemostcommonissueswithSolarWindsOriondatabasesarerelatedtothe
databasesize.Properlymanagingsizecanhelpyouavoidissueswithstorage
capacityanddatabaseperformance.Aprimaryfactorindatabasesizeisthedata
retentionsettingsavailableinSolarWindsOrion.EachSolarWindsOrionProduct
allowsyoutomanagethedatarollupperiodsandthedataretentionlimit.The
impactofadjustinganyofthesedataretentionandrollupwindowswillberoughly
proportionaltotheeffecttheOrionProducthasonthedatabasesize.When
consideringexpandingadataretentionperiod,youmaybeabletomakesmall
changesandexaminetheimpactonsizeandperformanceasyouapproachthe
desirednewlimit.
Notallofthedatarollupperiodsareadjustable.Typically,youcanalterone
intermediatedatarollupperiodandthelimitfordataretention.
Theimpactofalteringdataretentioncanbesummarizedbythisrule:Theshorter
thedatainterval,thegreatertheeffectthesettingwillhaveonthedatabasesize.
l
Extendingthedetaileddataretentionwillhavethelargestpotentialimpact
ondatabasesizeandperformance.
l
Extendinghourlyretentionwillhavealessereffect.
l
Extendingdailyretentionwillhavetheleasteffect.
Thisisduetothesummarizationofdetaileddataintohourlydataincrementsand
thenintodailydataincrements.EachSolarWindsOrionProductallowssimilar
dataretentionoptionsandtheaboveguidelinesshouldbefollowedforeach
product.
TroubleshootingYourOrionDatabase
TwoofthemostcommonsymptomsofdatabaseissuesaredegradedOrion
performance,anderrorsrelatedtotheinabilitytoconnecttothedatabase.
653
VB.NET PDF Text Extract Library: extract text content from PDF
'Please have a quick test by using the following example code for text extraction from PDF file in VB.NET program. ' Open a document.
extract pdf form data to xml; extracting data from pdf forms to excel
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
below. DLLs for PDF Image Extraction in VB.NET. Document. Sample for extracting all images from PDF in VB.NET program. ' Open a document.
extracting data from pdf files; extracting data from pdf to excel
Note:Thissectioncoversonlythebasicsofdeterminingadatabaseissueasthe
issuepertainstointeractionwithOrion.ItisnotintendedasanSQL
troubleshootingguide.
IntheOriondatabase,thesinglemostimportantSQLserverperformance
measurementisdiskqueuelength.QueuelengthisameasurementoftheSQL
writesthatarewaitingtobewrittentodisk.Whendiskqueuesstartlengthening
andthereisasteadyloadontheSQLwrites,thequeuesmaygrowsolargethat
writerequestsgetdropped.Thismayleadtogapsindataandwillaffectthe
overallperformanceoftheSQLserver.Agoodruleofthumbisthatdiskqueue
lengthshouldnotexceedtwotimesthenumberofeffectivespindlesintheSQL
storage.Theeffectivespindlecountisthenumberofstripedspindles.ForaRAID
10directattachedstorageunitwitheighttotaldisks,theeffectivespindlecountis
four.Fourofthespindlesinthisarrayaretheprimarystripedarrayandtheother
fourareasecondarystripedmirrorofthefourprimaryspindles.Sinceno
performancegainisachievedbymirroringdisks,onlytheprimarystripedsetis
usedtomeasureperformance.
Foradditionalinformationondatabaseperformance,seetheManaging
Orion
Performance
Technical
Reference
(PDF).
Whenerrorsoccurthatpointtoalossoftheconnectiontothedatabasethe
followingstepscanhelpisolatetheissue:
1. PingtheSQLserverfromtheOrionservertochecknetworkconnectivity.
2. OpenSQLServerManagementStudioortheOrionDatabaseManagerand
attempttoconnecttothedatabase.
3. Ifbothoftheabovearesuccessful,runtheOrionConfigurationWizard
againstthedatabasebyselectingDatabaseinthefirstwizardscreen.
Ensurethatyouareusingtheproperdatabasecredentials.
4. OpentheOrionwebUItotestconnectivityagain.
5. TestopeninganODBCconnectionfromtheOrionserverusingaMicrosoft
utilitysuchasODBCPing
.
Ifallofthisfails,thentheissueisafailurewiththeSQLserver.Atthispoint,you
willneedtogodirectlytotheSQLserverandbegintroubleshooting.
TroubleshootingSQLisveryspecificforeachversionandimplementation,andit
isrecommendedthatyouconsulttheMicrosoft
Support
site
andsearchfor
informationpertainingtoyourversion.
654
TroubleshootingYourOrionDatabase
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
C# Project: DLLs for PDF Image Extraction. In Document. C# programming sample for extracting all images from PDF. // Open a document.
exporting data from excel to pdf form; extract data from pdf using java
C# PDF File Merge Library: Merge, append PDF files in C#.net, ASP.
Merge Microsoft Office Word, Excel and PowerPoint data to PDF form. PDF document splitting, PDF page reordering and PDF page image and text extraction.
vb extract data from pdf; export pdf form data to excel spreadsheet
Chapter23:ManagingtheOrionDatabase
Upgrading YourDatabase
Atsomepoint,youmayneedtoupgradeormoveyourOriondatabase.For
example,youmayhavetochangeyourversionofMicrosoftSQLServerormove
yourdatatoadifferentserver.Thissectiongivesinformationonbackingupyour
currentdatabase,reinstallingitonanewserverandthenreconfiguringOrionto
usethisdatabase.
Requirements
Beforeyouattempttomodifyorbackupyourexistingdatabase,ensure:
l
Thenewdatabaseserverisinstalledcorrectly.
l
TheSQLBrowserServiceisrunningontheservertowhichyouaremoving
yourexistingdatabase.ThisservicerunsonUDPport1434,anditmaybe
blockedbyinternalfirewalls.
l
YouhavethesapasswordforbothyourexistingOriondatabaseserverand
yournewdatabaseserver.
l
Youhavethecredentialstoanaccountwithadministratorrightsonboth
yourexistingOriondatabaseserverandyournewdatabaseserver.
l
Youhavescheduledamaintenancewindowduringwhichyoucansafely
shutdownyourOrionservices.Youneedtostopdatacollectiontoensure
thatyourbackupfilematchesyourlastactivedatabasestate.
StoppingOrionServices
Beforeyoubackupyourdatabase,itisimportanttostoptheOrionservicesthat
arecurrentlywritingtothedatabase.Thisensuresthatyoudonothavedata
inconsistencieswhenyoubringyournewdatabaseserveronline.
TostopOrionservices:
1. ClickStart>AllPrograms>SolarWindsOrion>AdvancedFeatures>
OrionServiceManager.
2. ExpandServices.
3. Clickeachservice,excepttheSQLServerservice,andclickStop.
655
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
document processing SDK supports PDF page extraction, copying and The portable document format, known as PDF document, is file that allows users to open & read
how to save a pdf form in reader; pdf data extraction open source
C# PDF Password Library: add, remove, edit PDF file password in C#
PDFDocument doc = PDFDocument.Open(intputFilePath, userPassword); // Define IsFillForm = true; // Content extraction is allowed true; // Add password to PDF file
how to extract data from pdf file using java; save pdf forms in reader
Notes:
l
IfyouhavemorethanonePollingEngine,youwillneedtostopeach
additionalPollingEnginebeforecontinuing.
l
DonotstoptheSQLService.TheSQLServiceneedstoberunningin
ordertomakethenecessarychangestothedatabase.
4. ClickFile>Exit.
CreatingaDatabaseBackup
WhenyourMicrosoftSQLServerwasinstalled,thedatabasemanagementutility,
ManagementStudio,shouldalsohavebeeninstalled.Youcanusethisutilityto
createandinstallbackupsofyourOriondatabase.
Theproceduresforbackingupyourdatabaseissimilarforeachversionandcan
befoundattheMicrosoftSupportwebsite:
l
SQL Server
2014
l
SQL Server
2012
l
SQL
Server
2008
R2
l
SQL
Server
2008
l
SQL
Server
2005
Whiletheseexternallinkswerecorrectatthetimeofwriting,theycannotbe
guaranteedafterthis.Iftherequiredpagehasbeenmoved,gototheMicrosoft
Support
page
andsearchfortheversionoftheSQLserveryouareusing.
RestoringaDatabaseBackup
AfteryouhavebackedupyourOriondatabase,youcannowrestoreitonthenew
server.Thisshouldbedonewiththemanagementtoolassociatedwiththenew
server.
Theproceduresforrestoringyourdatabaseissimilarforeachversionandcanbe
foundattheMicrosoftSupportwebsite:
l
SQL Server
2014
l
SQL Server
2012
l
SQL
Server
2008
R2
656
CreatingaDatabaseBackup
C# PDF - Extract Text from Scanned PDF Using OCR SDK
Field Data. Data: Auto Fill-in Field Data. Field: Insert Recognize scanned PDF document and output OCR result to class source code for ocr text extraction in .NET
pdf data extractor; collect data from pdf forms
C# TIFF: Use C#.NET Code to Extract Text from TIFF File
SDKs, C# users can easily add and perform text extraction functionality into Certainly, you may also render it to a PDF, Word or SVG Set the training data path
java read pdf form fields; pdf form save in reader
Chapter23:ManagingtheOrionDatabase
l
SQL
Server
2008
l
SQL
Server
2005
Whiletheseexternallinkswerecorrectatthetimeofwriting,theycannotbe
guaranteedafterthis.Iftherequiredpagehasbeenmoved,gototheMicrosoft
Support
page
andsearchfortheversionoftheSQLserveryouareusing.
UpdatingOriontoUseNewDatabase
AfteryouhaverestoredyourOriondatabasebackupfile,youmustupdateyour
Orionservertorecognizetherestoreddatabaseonthenewdatabaseserver,as
showninthefollowingprocedure.
Note:SolarWindsrecommendsthatyouuseSQLServerAuthenticationwiththe
sa loginandpasswordtoensurethatOrioncanalwaysaccessyourSQLServer
database,evenifitishostedremotelyonaseparateserver.
ToupdateOriontouseanewdatabase:
1. LogontoyourOrionserver.
2. ClickStart>AllPrograms>SolarWindsOrion>Configurationand
Auto-Discovery>ConfigurationWizard.
Note:InolderversionsofOrion,thecorrectpathmaybeStart>All
Programs>SolarWindsOrion>ConfigurationWizard.
3. CheckDatabase,andthenclickNext.
4. SpecifyyournewdatabaseserverintheSQLServerfield.
5. TouseSQLauthentication,checkUseSQLServerAuthentication,and
thenprovidetheappropriatecredentials.
Note:SolarWindsrecommendsthatyouusethesaloginandpasswordfor
yourdatabaseservertoensurethatyouareabletoproperlyconfigurethe
Oriondatabaseuseraccount.
6. ClickNext.
7. SelectUseanexistingdatabase,selectortypetheexistingdatabase
name,andthenclickNext.
8. Ifyouarepromptedtousetheexistingdatabase,clickYes.
657
9. SelectCreateanewaccount,andthenprovideaNewAccountname.
Notes:
l
CreatinganewaccountensuresthatOrionhasrequiredaccessto
yourmigrateddatabase
l
TheNewAccountmustbeamemberofthesecurityadminserver
role
l
Thesysadminroleandthesauseraccountarealwaysmembersof
securityadmin
10. ProvideandconfirmanaccountPassword.
11. ClickNexttostartdatabaseconfiguration,andthenclickFinishtoexitthe
ConfigurationWizard.
Creating aMaintenancePlan with SQL Server
Management Studio
WhileitisnotwithinthescopeofthisAdministrationGuidetocovertheuseofthe
anyoftheMicrosoftSQLServeranditsassociatedtools,thefollowingprocedures
givesabriefguidetoconfiguringadailyOriondatabasemaintenanceplanusing
theSQLServermanagementtoolprovidedwithyourserver.
Notes:
l
Yourspecificenvironmentmayrequireadditionalconfiguration.
l
YoumayneedtocontactyourdatabaseadministratortogainaccesstoSQL
ServerManagementStudioforyourOriondatabase.
l
Thefollowingprocedureclearshistoricalmaintenancerecordsandcreates
abackupofyourOriondatabase.Ingeneral,however,SolarWinds
recommendsthatyoucontactyourdatabaseadministratorandreferencethe
MicrosoftdocumentationprovidedwithSQLServerforinstructionsonusing
SQLServerManagementStudiotomanageyourOriondatabase.
TouseSQLServerManagementStudiotomanageyourOriondatabase:
1. ClickStart >MicrosoftSQLServer >SQLServerManagementStudio.
2. ClickView >ObjectExplorer.
658
CreatingaMaintenancePlanwithSQLServerManagementStudio
Chapter23:ManagingtheOrionDatabase
3. ExpandtheSQLServerinstancecontainingyourOriondatabaseinthe
ObjectExplorerpaneontheleft.
Note:ExpandtheDatabasesfolderforanyinstancetoconfirmincluded
databases.Bydefault,theOriondatabaseisnamedSolarWindsOrion.
4. ExpandtheManagementfolder,right-clicktheMaintenancePlansfolder,
andthenclickMaintenancePlanWizard.
Note:TheMaintenancePlansfolderwillonlybevisibleifyouhave
Administratorrights.
5. ClickNexttostarttheSQLServerMaintenancePlanWizard.
6. ProvideanappropriateNameandDescriptionforyourmaintenanceplan.
7. ClickBrowse(…)nexttotheServerfield.
8. CheckyourSQLServer\Instance,andthenclickOK.
Note:IfyourSQLServer\Instanceisnotinthelist,provideitmanually.
9. SelecttheauthenticationtypethatisusedtoconnecttotheSQLserver,
and,ifrequired,provideappropriateUsernameandPasswordcredentials.
Note:Usethesameauthenticationtypeandcredentialsyouprovidedinthe
OrionConfigurationWizardtoaccessyourOriondatabase.
10. CheckCleanUpHistoryandBackUpDatabase(Full)Note:Whenatask
isclicked,theMaintenancePlanWizardprovidesabrieftaskdescription.
11. ClickNext.
12. Settheorderoftaskexecution,toptobottom,byselectingtasksandclicking
MoveUpandMoveDownasneeded.
Note:ThefollowingstepsassumetheCleanUpHistorytaskprecedesthe
BackUpDatabase(Full)task.
13. ClickNextwhenthetaskexecutionorderisset.
14. OntheDefineCleanupHistoryTaskview,checkthetypesofhistoricaldata
todelete,andthensetthethresholdageforhistoricaldataremoval.
15. ClickNext.
16. OntheDatabaseBackUp(Full)view,completethefollowingsteps:
a. ClicktheDatabasesfield.
b. SelectThesedatabases.
c. CheckyourOriondatabase.
659
17. ClickOK.
18. SelectDatabaseintheBackupcomponentarea.
19. IntheDestinationarea,completethefollowingsteps:
a. SelectDisk.
b. SelectCreateabackupfileforeverydatabase.
c. ClickBrowse(…)toselectanappropriatedatabasebackupfile
destinationwithsufficientfreespace.
20. ClickNext.
21. OntheSelectPlanPropertiesview,clickChange.
22. Configurethedatabasemaintenancejobscheduleasfollows:
a. ProvideanappropriateNameforthenewjobschedule.
b. SelectRecurringastheScheduletype.
c. CheckEnabled,andthenselectDailyintheOccursfield.
d. Provideanoff-peaknetworkusagetimeintheOccursonceatfield.
e. SelectaStartdate,andthenselectNoenddate.
23. ClickOK.
24. ClickNext,andthencheckWriteareporttoatextfile.
25. ClickBrowse(…)toselectanappropriatemaintenancereportfile
destination.
26. Reviewwizardresults,clickFinish,andthen,whenthewizardsuccessfully
finishes,clickClose.
ForfurtherinformationonusingSQLserverManagementStudio,visitthe
MicrosoftSupportWebsiteathttp://support.microsoft.com
.
660
CreatingaMaintenancePlanwithSQLServerManagementStudio
Documents you may be interested
Documents you may be interested