Pdf data extraction open source SDK application service wpf windows html dnn OrionNPMAdministratorGuide65-part1691

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.

Extendingthedetaileddataretentionwillhavethelargestpotentialimpact

ondatabasesizeandperformance.

Extendinghourlyretentionwillhavealessereffect.

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:

Thenewdatabaseserverisinstalledcorrectly.

TheSQLBrowserServiceisrunningontheservertowhichyouaremoving

yourexistingdatabase.ThisservicerunsonUDPport1434,anditmaybe

blockedbyinternalfirewalls.

YouhavethesapasswordforbothyourexistingOriondatabaseserverand

yournewdatabaseserver.

Youhavethecredentialstoanaccountwithadministratorrightsonboth

yourexistingOriondatabaseserverandyournewdatabaseserver.

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:

IfyouhavemorethanonePollingEngine,youwillneedtostopeach

additionalPollingEnginebeforecontinuing.

DonotstoptheSQLService.TheSQLServiceneedstoberunningin

ordertomakethenecessarychangestothedatabase.

4. ClickFile>Exit.

CreatingaDatabaseBackup

WhenyourMicrosoftSQLServerwasinstalled,thedatabasemanagementutility,

ManagementStudio,shouldalsohavebeeninstalled.Youcanusethisutilityto

createandinstallbackupsofyourOriondatabase.

Theproceduresforbackingupyourdatabaseissimilarforeachversionandcan

befoundattheMicrosoftSupportwebsite:

SQL Server

2014

SQL Server

2012

SQL

Server

2008

SQL

Server

2008

SQL

Server

2005

Whiletheseexternallinkswerecorrectatthetimeofwriting,theycannotbe

guaranteedafterthis.Iftherequiredpagehasbeenmoved,gototheMicrosoft

Support

page

andsearchfortheversionoftheSQLserveryouareusing.

RestoringaDatabaseBackup

AfteryouhavebackedupyourOriondatabase,youcannowrestoreitonthenew

server.Thisshouldbedonewiththemanagementtoolassociatedwiththenew

server.

Theproceduresforrestoringyourdatabaseissimilarforeachversionandcanbe

foundattheMicrosoftSupportwebsite:

SQL Server

2014

SQL Server

2012

SQL

Server

2008

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

SQL

Server

2008

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:

CreatinganewaccountensuresthatOrionhasrequiredaccessto

yourmigrateddatabase

TheNewAccountmustbeamemberofthesecurityadminserver

role

Thesysadminroleandthesauseraccountarealwaysmembersof

securityadmin

10. ProvideandconfirmanaccountPassword.

11. ClickNexttostartdatabaseconfiguration,andthenclickFinishtoexitthe

ConfigurationWizard.

Creating aMaintenancePlan with SQL Server

Management Studio

WhileitisnotwithinthescopeofthisAdministrationGuidetocovertheuseofthe

anyoftheMicrosoftSQLServeranditsassociatedtools,thefollowingprocedures

givesabriefguidetoconfiguringadailyOriondatabasemaintenanceplanusing

theSQLServermanagementtoolprovidedwithyourserver.

Notes:

Yourspecificenvironmentmayrequireadditionalconfiguration.

YoumayneedtocontactyourdatabaseadministratortogainaccesstoSQL

ServerManagementStudioforyourOriondatabase.

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