processorenableviewstate

435GlossaryBusinessIntelligenceTerminologycubeMultidimensionaldataprocessedbyasingleMDDB.
datamartOftenusedtorefertothestagingdatabase,OLAPServices,andreportserverrelatedtoaparticularsetofbusinessprocesses,suchasSalesorMarketing.
Companiesoftenhavemultipledatamarts.
dataminingStatisticalanalysisofdata,usuallywithapredictiveorientation.
Youcandodataminingagainsteitherrelationalormultidimensionaldata.
However,therequiredanalysisisoftenmuchmoreefficientwhenmultidimensionaldataisused.
Theresultsofdata-mininganalysisarestoredinseparatestructuresandarequeriedseparatelyfromthesourceMDDB.
AnalysisServicesincludesadata-miningcomponent.
datawarehouseThecollectionofalldatamartsinacompany.
Somebusinessintelligence(BI)vendorsalsousethetermtorefertocertainpiecesoftheoverallarchitecture,suchasjustthestagingdatabaseorjustOLAPServices.
InSQLServer,forexample,theAdventureWorkssamplereferstothestagingdatabaseasthedatawarehouse.
dimensionTheperipheraltablesofeitherastarschemaorasnowflakeschema,whenthecentraltableisafacttable.
Dimensiontablesnormallycontainmostlystringsintheirnon-keycolumns.
Somearchitecturesrequirethatalloriginalkeysbereplacedwithsurrogatekeys,whichsimplifiescertaintypesofupdates.
GLOSSARY436DMXDataMiningExtensions.
Thelanguageusedtoquerydata-miningstructures.
ETLExport,TransformandLoad.
Theprocessofexporting(reading)datafromasourcedatabase;transformingitthroughaseriesofstepsthatmayincludecleaning,duplicateremoval,schemamodifications,andsoon;andloadingthedatainadestinationdatabase.
SQLServerIntegrationServices(SSIS)isanexampleofanETLtool.
facttableThecentraltableofastarorsnowflakeschema,withcolumnsthatarealleithernumericorforeignkeystothedimensions.
Examplesofnumericcolumnsincludeprice,quantity,weight,extendedprice,anddiscount.
Youcanrepresentdatesasforeignkeysinthefacttablethatrefertoadatedimension.
Thedatedimensionprovidesabreakdownofthedatebyweek,month,quarter,year,andsoon.
HOLAPHybridOLAP.
Amodeinwhichsomedata,suchasaggregations,isstoredlocally,anddetaileddataisstoredinaremoteRDBMS.
KPIKeyPerformanceIndicator.
Inthegenericsense,ahigh-levelcalculatedvaluethatgivesanideaabouttheperformanceofsomeaspectofabusiness.
Forexample,totalrevenueisatypicalKPI.
KPIsinMicrosoftproductshaveamorespecificdefinitionthatincludesiconstorepresentgood,caution,andbad(suchgreen,yellow,andredstoplights),alongwithoptionaladditionaliconstorepresenttrends—up,down,andsideways.
MDDBSMultidimensionalDatabaseSystem.
AlsocalledanMDDB.
Adatabasethatisoptimizedforworkingwithmultidimensionaldata(sometimescalledOLAPServices).
SQLServerAnalysisServices(SSAS)isanexampleofanMDDB.
Alsoreferstoacollectionofcubes.
MDXMultidimensionalExpressions.
ThelanguageusedtoqueryOLAPServices.
MicrosoftprovidessupportforMDXbothdirectlyinBusinessIntelligenceDeveloperStudio(BIDS)andprogrammaticallywithADOMD.
NET.
measureAnumericcolumninafacttable.
Measuresaresometimesusedtorefertoindividualnon-keycellsinafacttable.
GLOSSARY437measuregroupAsinglefacttableanditsrelateddimensions.
TherecanbemultiplemeasuregroupspercubeinAnalysisServicesinSQLServer2005andlater.
SQLServer2000supportsonlyonemeasuregrouppercube.
MOLAPMultidimensionalOLAP.
AmodeinwhichOLAPqueriesarerunagainstadatastorethat'slocaltotheMDDB.
WhenacubeisprocessedbySSAS,datafilesarecreatedinthelocalfilesysteminMOLAPmode.
Becausethecubecanbere-createdfromthesourcedatabase,thisisalsosometimescalledaMOLAPcache;butitcontainspreprocessedaggregatesandothermetadata,sostrictlyspeakingitismoreatransformationofthesourcedatathanacache.
multidimensionaldataOnefacttableormoreandtheassociateddimensions,transformedandoptimizedforprocessing,includingaggregation(sums,totals,counts,andsoon)andgroupingbyhierarchiesortime.
Multidimensionaldataisnolongerrelational.
Aftertransformation,multidimensionaldataiscalledacube.
OLAPOnlineAnalyticProcessing.
TheprimarytypeofprocessingdonebyanMDDB.
OLTPOnlineTransactionalProcessing.
TheprimarytypeofprocessingdonebyanRDBMS.
RDBMSRelationalDatabaseManagementSystem.
Whatmostusersconsidertobetheircentraldatastore,oftenreferredtoasjustadatabase.
SQLServer'sRelationalDatabaseisanexample.
reportserverAdedicatedservertohandlecreationanddistributionofreportsthatarebasedonqueriestoeitheranMDDBoranRDBMS.
Somearchitecturesalsousequeriestothestagingdatabaseforcertaintypesofreports.
Queriesagainstproductiondatabasesforreportingpurposesonlyarestronglydiscouraged,duetotheirgenerallynegativeimpactonperformanceandscalability.
GLOSSARY438ROLAPRelationalOLAP.
AmodeinwhichOLAPqueriesarerunagainstaremoteRDBMS.
RatherthanprecomputingaggregatesasinMOLAP,theyarecomputedontheflyusingSQLqueriesagainstthesourceRDBMS.
Asaresult,thismodetendstobemuchslowerthanMOLAP.
stagingdatabaseAnRDBMSthatsitsbetweenproductiondatabaseserversandanMDDB.
Productiondatabaseshaveanumberofattributes,suchasahighdegreeofnormalization,thattendtomakethemaninefficientsourceforanMDDB.
Acommonsolutiontothisproblemisthecreationofoneormorestagingdatabases.
AnETLprocessreadsdatafromtheproductiondatabasesandstoresitinastarorsnowflakeschemainthestagingdatabase.
TheMDDBisthenloadedandrefreshedfromthestagingdatabase.
Thisalsohelpsminimizetheloadimpactonproductionservers.
Theamountofhistoryretainedinthestagingdatabaseistypicallymuchlargerthanintheproductiondatabases.
Usingastagingdatabaseforhistoricalqueriesoftenhelpsimprovethescalabilityoftheproductionservers.
Somearchitectsdon'tallowqueriesagainstthestagingdatabase,andothersdo(I'minthelattercamp).
starschemaArelationalschemathatconsistsofasinglecentraltableandmultipleperipheraltables.
Theperipheraltablescontainprimarykeysthatarereferencedbyforeignkeysinthecentraltable.
Afullyconnectedsetofrelationaltablescanbetransformedintoastarschemausingdenormalization,wherepartsofmultipletablesarejoinedtogethertoformthecentraltable.
starsnowflakeschemaAstarschemathatincludesadditionaltablesthatarereferencedbykeysintheperipheraltables.
Atmostonelevelofindirectionexistsbetweentheoutermosttablesandthecentraltable.
Alsocalledasnowflakeschema.
449IndexSpecialCharacters$(dollarsign),206~(tildecharacter),319codeblock,28Numerics/3GBflag,26432-bitsystems,memoryorganization,26464-bitsystems,memoryorganization,26464KBextents,264302Foundredirects,249304NotModifiedmessage,74404NotFounderrors,134Aabsolutepositioning,64,423Acceptheader,44Accept-Languageheader,103accessors,266ACKpackets,15—16AcquireReaderLock()method,187AcquireRequestStateevent,197ActionTypeenum,181active-activeconfiguration,345ActiveViewIndexproperty,215ADALabstractclass,284adapterTypeproperty,218AddCacheRuledialog,IISManager,106AddCustomHTTPResponseHeaderdialog,IISManager,38AddNewProjectdialogbox,VisualStudio,311—312AddorEditResourceAllocationdialogbox,WSRM,132AddRuledialogbox,WSRM,131Addrule(s)dialogbox,IISManager,146AddVirtualDirectoryoption,IISManager,145AddWebDeploymentProjectoption,VisualStudio,29AddWebReferencedialog,VisualStudio,174AddBrowser()method,219AddBrowserBegin()method,284AddBrowserEnd()method,284AddCacheDependency()method,113—114AddCacheItemDependency()method,113AddMachinestoredprocedure,238AddressWindowingExtensions(AWE),264AddValidationCallback,116AdobePhotoshopcompression,32—33costof,10imageslicing,34AdomdCommandobject,371AdomdConnectionobject,371ADOMD.
NETlibrarymultiple-rowresults,372—373overview,350—351,369—370single-cellresults,370—371ADO.
NET,commandbatchingfor,267AdvancedOutputCacheRuleSettingsdialogbox,IISManager,109—110AdvancedSettingsdialog,IISManager,128agents,SCOM,409aggregationqueriesavoiding,346cachingresults,349performanceimpact,265,286agilitygoal,3Ajaxavoidingfullpageloads,9INDEX450clientperformance,52—55precaching,62searchengines,251alert()function,221Allowclause,150allowCustomSqlDatabaseobject,196AnalysisServicesProcessingTask,374antivirussoftware,403APP_NAME()function,338appendChild()method,26Applicationlogoperatingsystem,269Applicationobject,117applicationpolicies,229—261avoidingredirectsafterpostback,258batchcompilation,260controladapters,247—249customHttpHandlers,230—240customHttpModulesBeginAuthenticateRequesteventhandler,233—235databasetableandstoredprocedures,237EndAuthenticateRequesteventhandler,235—236EndRequesteventhandler,236—237Init()method,231—232PreRequestHandlerExecuteeventhandler,232registeringinweb.
config,238requirementsforexample,230—231disablingdebugmode,259—260earlyresponseflush,250—255chunkedencoding,254—255code-behind,251—252markup,251packettrace,252—254pageadapters,242—244PageAdapterclass,244PageStatePersisterclass,242—243Pagebaseclass,241—242pagerefresh,identifying,258Page.
IsPostBackflag,checking,257redirects,249—250conventional,249permanent,249—250Server.
Transfer()method,250Response.
IsClientConnectedflag,checking,258—259tagtransforms,247URLrewriting,244—246fromHttpModule,245—246modifyingformstouserewrittenURLs,246whitespacefiltering,255—257applicationpools(AppPools),165—179asynchronousfileI/O,176—177asynchronouspages,166—167asynchronouswebrequests,178—179asynchronouswebservices,173—176executingmultipleasynctasksfromsinglepage,170—172handlingtimeouts,172—173improvingscalabilityofexistingsynchronouspages,170loadtest,167—170overview,127—129synchronouspages,165Application_Start()method,325applicationHost.
configfile,107ApplicationSettingsobject,99—100AppPools.
Seeapplicationpoolsarbitrarytext,protectingagainstinjectionof,80architecture,420—422archivingdata,315—316arrays,T-SQLand,276.
ashxfiles(generichandlers),239tag,202—203tag,203control,371control,270ASP.
NETcachevalidation,116—117objectcaching,117—122databasedependencies,120—121file-baseddependencies,119—120objectsusedbymorethanonepagerequest,118—119objectsusedonlybycurrentrequest,117—118objectswithglobalscopeandindefinitelifetime,117WeakReferenceobject,121—122outputcaching,110—117cachevalidation,116—117cachingpagefragmentswithusercontrols,111databasedependencies,113—115disabling,112removingitemsfromoutputcache,113substitutioncaching,112INDEX451varyingoutputcache,115—116settingcookies,102threadpool,271.
aspxpagesreadingcookies,90settingcookies,86—90asyncmechanismsin.
NET,271asyncpoint,164asynctasksexecutingafterPreRenderevent,171—172multiple,executingfromsinglepage,170—172AsyncCallbackobject,176,235asynchronousAjaxcalls,282asynchronousfileI/O,176—177asynchronouspages,166—167,170asynchronouswebrequests,178—179asynchronouswebservices,173—176AsyncTimeoutproperty,172AuthenticateRequestevent,232AutoIDelementsonpasteinSourceviewoption,VisualStudio,203AutoEventWireupflag,241Availablepercentageofprocessorremainingmetric,WSRM,133Avg.
DiskQueueLengthcounter,SQLServer,343Avg.
Disksec/Transfercounter,SQLServer,343AVIcode,servermonitoring,409AWE(AddressWindowingExtensions),264Bbackgroundimages,optimizing,31—32backgroundthreads,179—186Init()method,232issuingprecachecommand,282forlogging,181—186queueingworkitemto,283taskserialization,186bandwidththrottling,152—154base-64encoding,91,93batchcompilation,260batchingcommands,267—273parameterizedcommandstrings,building,271—273SqlDataAdapterobject,267—271limitationsof,271resultsof,270—271BEGINstatement,275BeginAsync()method,166—167,300,330BeginAsyncHandler()method,186BeginAuthenticateRequesteventhandler,233—235BeginExecuteNonQuery()method,167,235,273BeginExecuteReader()method,300BeginGetPlaceFacts()method,176BeginInvoke()method,180BeginProcessRequest()method,240BeginRender(),217beta-testphases,414BI(businessintelligence),349BIDS(BusinessIntelligenceDevelopmentStudio),353binarydata,storingincookies,91—94BinaryFormatterobject,84,198BitRateThrottlingextension,IIS,152Bitmapobject,225section,resourcerequestsin,17Booleanoperators,full-textsearch,319boot.
inifile,adding/3GBflagto,264control,98bots,managingloadfrom,150—152Bringonlineimmediatelyoption,SSAS,380brownbagtalks,417browsercaching,73—77cachingdynamiccontent,76—77cachingstaticcontent,73—75overview,18—19browserpageprocessing,14—18networkconnectionsandinitialHTTPrequest,14—16pageparsingandnewresourcerequests,16—17pageresourceorderandreordering,17—18Browserproperty,216browsersbehaviorof,9cross-browsercompatibility,10browser-specificcode,212—220browserproviders,218—219cachingbrowser-specificpages,215—216cloaking,220controladapters,216—218propertyprefixes,214—215Request.
Browserobject,213—214Buffercachehitratiocounter,SQLServer,343buffers,flushingfrommemory,289bugbar,415bugtracking,415INDEX452burstdisk-writeperformance,391businessintelligence(BI),349BusinessIntelligenceDevelopmentStudio(BIDS),353control,98CCacheobject,118,426cacheprofiles,usinginweb.
config,425cachevalidationcallback,426cachewarm-up,408Cache-ControlHTTPheader,102—103staticcontent,103usingcookieswithproxies,102—103Cache-Control:max-ageheader,73—75,139Cache-Control:no-cacheheader,75,103,139Cache-Control:privateheader,76,102—103Cache-Control:publicheader,102—103,106CacheDependencyobject,119—120CacheItemPriorityobject,119caching,71—126.
Seealsocookies;ViewStateobject,protectingdataintegrityof;webservercacheatalltiers,8,72—73inbrowsercache,73—77dynamiccontent,76—77staticcontent,73—75browser-specificpages,215—216compressedcontent,143distributed,123—124expirationtimes,124—125dynamiccontent,124staticcontent,124—125isolatedstorageofSilverlightapplications,96—101deployingandupdating,101WelcomeBacksampleapplication,96—100precaching,281—283approachto,282forms-baseddata,282page-at-a-timedata,283proactive,377—381cachingmodes,378—381datastorageoptions,377proxycache,101—103SQLServercaching,122cachingcontrols,205CAOvalue,95capacityplanning,390casesensitivitybrowsercaches,18compression,30URLs,205CassiniwebserverCache-Controlheader,102compression,140HttpModuleobject,230,238categorizingcounters,387CDN(contentdistributionnetwork),224CellSetobject,373CHECKPOINTcommand,SQLServer,289checkpoints,265Classicmode,IIS,130clientperformance,13—69Ajax,52—55browsercaching,18—19browserpageprocessing,14—18networkconnectionsandinitialHTTPrequest,14—16pageparsingandnewresourcerequests,16—17pageresourceorderandreordering,17—18CSSoptimizations,45—49DHTML,leveraging,52imageclustering,49—52imagesprites,49—52JavaScriptgatingpagerequests,39—41optimizations,66—67reducingHTMLsize,41—43networkoptimizations,19—21overview,13—14precaching,61—63CSS,62—63images,62JavaScript,62—63renderingspeed,60—61includefilehandlingeliminatingCSSround-tripsforfirstpageview,37—39HTML,35—37,39increasingparallelismbyqueuingresourcesbeforefiles,22—23minimizingnumberoffiles,23—25requestingobjectsafterrestofthepage,26,26INDEX453server-sidealternatives,26—34Websiteiconfile,34—35Silverlight,55—60buildingHTMLcontrols,55—58callingintofromJavaScript,58—59tablelesslayoutusingCSS,64—66uploadingless,43—45client-sideimagemaps,34cloaking,220Close()method,301clusteredindexes,288—290,430clustering,344—345,392coding,indevelopmentprocess,415codingstandards,importanceofestablishing,417tag,425commandbatching,267—273buildingparameterizedcommandstrings,271—273SqlDataAdapterobject,267—271limitations,271results,270—271CommandNotificationobject,114COMMITTRANSACTIONstatement,275commontableexpressions(CTEs),295—296CommunityTechnologyPreviews(CTPs),416compactpolicy(CP)value,95compactprivacypolicy,94—95compilingpages,407—408Complete()method,274CompletedSynchronouslyflag,178CompleteRequest()method,249compression,139—144cachingcompressedcontent,143configuring,usingweb.
config,142—143enabling,140—141,144image,optimizing,32—33maximizing,30settingoptionsfor,141—142Compressionconfigurationpanel,IISManager,141concurrentrequests,increasingnumberof,169conditionalGETs,avoiding,73—74conditionalHTTPrequests,73—74ConnectionManagerdialogbox,SSAS,374—375consumerdrives,biterrorrates,396CONTAINSclause,317—319CONTAINSTABLEclause,318—319contentcompressed,143dynamic,76—77,105—107managingdifferentversionsof,103static,73—75,103contentdistributionnetwork(CDN),224Content-TypeHTTPheader,61Context.
Itemsobject,426Contigutilitycostof,10defragging,393CONTRACTobject,320—321controladapters,216—218,247—249controlcaching,205controllercache,398—399ControlStateobject,79controlTypeproperty,218conventionalredirects,249CONVERSATIONobject,321—322cookieNameproperty,190CookiePathparameter,232—233cookies,85—96asalternativetosessionstate,199bots,151compactprivacypolicy,94—95disabling,10enablesbyclient,234identifyingpagerefreshes,258managing,96multiplename/valuepairsinsingle,86propertiesof,86—96domainproperty,88—89expiresproperty,87HttpOnlyproperty,89pathproperty,87—88readingvalues,90—91secureproperty,90withproxies,102—103sessioncookies,setting,86storingbinarydatain,91—94uploading,44—45CORvalue,95COUNTaggregationquery,286counters,386coveredindex,creating,292—293coveredquery,285CP(compactpolicy)value,95CPUcores,341CPUlimitations,131,133—134,162CPUtime,289cross-sitescripting,402CSSINDEX454dynamicallygenerating,220—223accessingASP.
NETcontrolsfromJavaScript,222—223exampleof,221—222eliminatinground-tripsforfirstpageview,37—39minimizing,28—30optimizations,45—49precaching,62—63propertyinheritance,46—47spritegenerators,49tablelesslayoutusing,64—66CSSFriendlyControlAdaptersproject,218CTEs(commontableexpressions),295—296CTPs(CommunityTechnologyPreviews),416cubesdefined,350,435processing,379—380updating,432currenttime,showingusingscript,52cursors,avoidinguseof,294customHttpHandlerobject,238—240customHttpModuleobject.
SeeHttpModuleobject,customcustomsessionIDmanager,193—194,196customtemplates,usinginVisualStudio,82—84Ddataaccesslayer(DAL),283—285DataGenerationPreviewpane,VisualStudio,314DataGenerator,SSAS,352—353datamarts,382,435datamining,435DataMiningExtensions(DMX),436datapaging,295—303commontableexpressions,295—296exampleof,296—303code-behind,298—301markup,296—297objectdatasource,302results,302—303storedprocedure,297datapartitioning,310—316addingindexandconfiguringlockescalation,314—315archivingolddata,315—316atdatatier,9generatingtestdata,311—314high-performancearrays,398partitionfunction,310—311partitionscheme,311dataprecaching,281—283approachto,282offorms-baseddata,282ofpage-at-a-timedata,283DataSourceViewWizard,SSAS,354DataSourceViews(DSVs),350datasources,350datatierpartitioningat,9upgrades,406—407datawarehouses,382,435databasedependencies,113—121Databaseperspective,monitoring,409databasesnapshots,beforeinitiatingupgrade,407databasesminimizingnumberof,346webpageloadingprocess,7writeperformance,192DataTableobject,304DBCCDROPCLEANBUFFERScommand,289DBCCSHOWCONTIGcommand,290deadlocks,avoidingperformanceproblemsdueto,294debugmode,disabling,259—260debuggingJavaScript,220defaultclustersize,NTFSfilesystem,392DEFAULTpool,337defense-in-depthtechniques,103DefineRelationshipdialogbox,SSAS,359deflatecompressionalgorithm,141—142defragmentationutility,392denial-of-serviceattacks,403dependenciesdatabase,113—121file-based,119—120deployment,406—408cachewarm-up,408datatierupgrades,406—407improvingdeploymentspeed,407pagecompilation,407—408Silverlightapplications,101depth-firstdevelopment(DFD),416Dequeue()method,184—185designphase,developmentprocess,412DeveloperDivision,Microsoft,413developmentprocess,413—418bugtracking,415INDEX455coding,415depth-firstdevelopment,416organization,413—414projectphasesandmilestones,414testing,415unittesting,417userfeedback,416DFD(depth-firstdevelopment),416dhrefproperty,40—41DHTML,leveraging,52DIALOGobject,321DimensionUsagepanel,SSAS,359DimensionWizard,SSAS,357—358dimensions,defined,350,357,435directories,virtual,145directorycaches,123disablingcaching,75—77debugmode,259—260outputcaching,112Disallowfield,150disambiguation,cookieswiththesamename,88diskpartitiondesign,394—395diskstriping,395disksubsystems,390—399controllercache,398—399diskpartitiondesign,394—395RAIDoptions,395—398RAID0andstripesize,395RAID1,395RAID3,396RAID5,396RAID6,396RAID10,396recommendations,396—398randomversussequentialI/Ospersecond,391—394solidstatedisks,399storagearraynetworks,398disktransferrates,sustained,394DiskTransfers/seccounter,SQLServer,343disks,I/Omanagement,8display:blockproperty,50DisplayEstimatedExecutionPlan,288Dispose()method,236,284,301tag,25,423DLLs,placingusercontrolsin,207DMX(DataMiningExtensions),436DNS(DomainNameSystem),7,404—405tag,425document.
write()avoiding,23—24deferredscripts,26DoDirMonitoringForUncregistrykey,104dollarsign($),206DomainNameSystem(DNS),7,404—405domainnames,referencingconsistently,18domainproperty,88—89downloadingless,27Dropoutdatedcacheoption,379,SSASDSPvalue,95DSVs(DataSourceViews),350dynamicadhocT-SQL,266dynamiccontentcaching,76—77enablingkernelcaching,105—107dynamicCompressionBeforeCacheobject,143,257,427dynamicCompressionLevelproperty,143E-Eflag,189EditNamedCalculationdialogbox,SSAS,355—356"eight-secondrule",4elevatoralgorithm,398e-mail,sendingviaservicebroker,323—331backgroundworkerthread,creating,324—325readingandprocessingmessages,325—328results,331webformtoqueuemessage,328—330Enableproactivecachingcheckbox,SSAS,379—380EnableROLAPaggregationsoption,SSAS,380EnableSessionStateproperty,191EnableThemingproperty,210,221enableVersionHeaderproperty,139EnableViewStateproperty,82,208encryptedcookies,91—93EndAsync()method,167,301—302EndAsyncHandler()method,186EndAuthenticateRequesteventhandler,235—236EndExecuteReader()method,301EndGetPlaceFacts()method,176EndProcessRequest()method,240EndRead()method,177EndRequesteventhandler,232,236—237INDEX456EndsWith(tail)match,88end-to-endWebpageprocessing,5—7EnlistTransaction()method,274Enqueue()method,183Enterprisedrives,biterrorrates,396EntityFramework,303,431environments,staging,405errorpages,136Errorstate,130escrow,trackingbugs,415ETagheader,removing,138—139ETL(export,transform,andload)process,383,436EXECcommand,271ExecuteCellSet()method,373executeInParallelflag,171—172ExecuteRegisteredAsyncTasks()method,172,300exist()clause,307ExpireWebContentoption,IISManager,74—75Expiresheader,73,76—77,139expiresproperty,87ExploreDataoption,SSAS,356export,transform,andload(ETL)process,383,436ExportTemplateWizard,VisualStudio,82—83ExpressionWebcostof,10HTMLoptimization,35—36extents,264Ffacttables,defined,436facts,defined,350FailedRequestTracing(FRT)feature,IIS,154—159,427favicon.
icofile,34—35FiddlerWebDebugger,10,136—137fileandfoldernames,lengthof,144filetypes,orderof,159file-baseddependencies,119—120filegroups,264FileStreamobject,177,393filesystemfragmentation,minimizing,345Fill()method,281Filter()method,257Firebug,10Firefoxbackgroundimages,31costof,10identifyingpagerefreshes,258imagesprites,50—51pageprocessing,14popularityof,10firewallsusingrouterasalternativeto,403WindowsFirewallandantivirussoftware,403first-partycookies,94—95fixedcontent,building,111flash-basedSSDs,399float:leftproperty,51Flush()method,251—252,254—255flushingresponsebuffer,250—255chunkedencoding,254—255code-behind,251—252markup,251packettrace,252—254folderhierarchies,144FormRewriteclass,247forms,modifyingtouserewrittenURLs,246forms-baseddata,precachingof,282fragmentedspace,392FREETEXTclause,318FREETEXTTABLEclause,318FRT(FailedRequestTracing)feature,IIS,154—159,427full-customsessionstate,197—198full-textsearch,316—319creatingfull-textcatalogandindex,316—317full-textqueries,317—318obtainingsearchrankdetails,318XMLqueries,309FxCoptool,418GgatingpagerequestswithJavaScript,39—41links,40—41submitbuttons,39—40GC(.
NETgarbagecollector),121—122generichandlers,239GETrequests,15—16,52GetCount()method,302getElementById()function,59GetMachine()method,194GetPage()method,299GetRows()method,302GetStatePersister()method,244GetVaryByCustomString()method,428GetVaryByCustomStringmethod,215INDEX457GIFfiles,32,423globalscope,cachingobjectswith,117Global.
asaxfiles,230Google,robot.
txtstandard,150gotlogo()function,28GridViewcontrol,81,281,296,372—373GUIDs,233—234,287gzipcompressionalgorithm,141GzipStream,94HHandlerMappingssection,IISManager,130hardware,goalsfor,3hardwarefirewalls,403hardwareloadbalancers,406section,resourcerequestsin,17HeisenbergUncertaintyPrinciple,412hexcolorcodes,48HOLAP(hybridOLAP)mode,SSAS,377,436horizontalscaling,341:hoverdirective,51—52HTMLavoidingoptimizationtechniquesthatviolatestandards,37buildingcontrolswithSilverlight,55—58minimizing,28—30optimizers,35—36usingJavaScripttoreducesize,41—43addingrepetitivetexttotags,43generatingrepetitiveHTML,41—42HTTP,134—1391.
0requests,blocking,101headers,136—139HTTP1.
1,139removingETagheader,138—139removingserverheader,137—138removingX-Aspnet-Versionheader,139removingX-Powered-Byheader,137response,16—17initialrequests,14—16keep-alives,144redirects,135—136HttpApplicationStateobject,426HttpBrowserCapabilitiesobject,219HttpCapabilitiesProviderobject,218—219section,142HttpHandlerobject,238—240,429HttpModuleobjectcustom,230—238BeginAuthenticateRequesteventhandler,233—235databasetableandstoredprocedure,237EndAuthenticateRequesteventhandler,235—236EndRequesteventhandler,236—237Init()method,231—232PreRequestHandlerExecuteeventhandler,232registeringinweb.
config,238requirementsforexample,230—231enforcingcookiepolicies,96limitingdownloadspeedof.
zipfiles,153—154rewritingURLs,146URLrewritingfrom,245—246HttpOnlyproperty,89http.
syscache,rewritingURLs,246http.
sysdriver,104—105,107—109,135HTTPSYS_CACHEABLElabel,158HttpValidationStatus.
Invalidsetting,116hybridOLAP(HOLAP)mode,SSAS,377,436IIAsyncResultobject,186ICOformat,34Idproperty,219IDENTITYinteger,286—287IDisposableobject,301IDscustomsessionIDmanager,193—194,196session,188—189If-Modified-Sinceheader,74,139If-None-Matchheader,74IHttpAsyncHandlerobject,239IIS(InternetInformationServices),127—160applicationpoolstuning,168—170webgardens,127—129compression,139—144cachingcompressedcontent,143configuring,usingweb.
config,142—143enabling,140—144settingoptionsfor,141—142FailedRequestTracing,154—159HTTPissues,134—139headers,136—139redirects,135—136HTTPkeep-alives,144INDEX458optimizingURLs,144—149rewriting,146—149virtualdirectories,145outputcaching,109—110performancetuning,159request-processingpipeline,130—131ResourceKitTools,107trafficmanagement,150—154bandwidththrottling,152—154sitemaps,151—152usingrobots.
txt,150—151WindowsSystemResourceManager,131—134IISManagerconfiguringcaching,73—75settingcookies,38imagesprites,49—52imagesbackground,31—32client-sideimagemaps,34clustering,49—52compressionanddimensions,32—33formats,choosing,32minimizingnumberofonpages,30resizing,224—226slicing,33—34specifyingsizeattributes,34themed,precaching,211usingtransparencyasalternativetorolloverimages,31tag,16—18indefinitelifetime,cachingobjectwith,117indexkeys,random,286indexscan,286indexes,285—294clustered,288—290covered,292—293examplewithnoindexes,287—288fragmentationof,293—294guidelines,286—287nonclustered,290—292performanceissues,286XML,308—309infrastructureandoperations,385—410capacityplanning,390deployment,406—408cachewarm-up,408datatierupgrades,406—407improvingspeed,407pagecompilation,407—408disksubsystems,390—399controllercache,398—399diskpartitiondesign,394—395RAIDoptions,395—398randomversussequentialI/Ospersecond,391—394solidstatedisks,399storagearraynetworks,398DNS,404—405establishing,412firewalls,402—403usingrouterasalternativeto,403WindowsFirewallandantivirussoftware,403instrumentation,385—389loadbalancers,403—404networkdesign,400—401jumboframes,400—401linkaggregation,401servermonitoring,408—409stagingenvironments,405Inheritedheadertype,137Init()method,184,231—232Initialize()method,195in-memorytablevariable,278in-memory-onlycachingtier,123innerHTMLproperty,67InProcmode,189input/output(I/O)asynchronousfile,176—177optimizing,8randomversussequential,391—394INSERTscommand,287instrumentation,385—389Integratedmode,IIS,130INTERNALpool,337InternetExplorercachingstaticcontent,73cost,10identifyingpagerefreshes,258popularity,10privacysettings,94—95InternetInformationServices.
SeeIISinvalid(stale)content,73invisibleproxies,21,101I/O(input/output)asynchronousfile,176—177optimizing,8randomversussequential,391—394IsClientConnectedflag,258—259INDEX459ISessionIDManagerinterface,193isolatedstorage,Silverlightframework,96—101deployingandupdatingSilverlightapplications,101WelcomeBacksampleapplication,96—100IsPostBackflag,257IsReusableproperty,240Itemscollection,117—118JJavaScriptavoidingfullpageloads,9callingintoSilverlightfrom,58—59cookiesreading,91setting,86—90disabling,10dynamicallygenerating,220—223accessingASP.
NETcontrols,222—223exampleof,221—222minimizing,28—30optimizingperformance,66—67precaching,62—63usingtogatepagerequests,39—41links,40—41submitbuttons,39—40usingtoreduceHTMLsize,41—43addingrepetitivetexttotags,43generatingrepetitiveHTML,41—42JavaScriptminifier,423JPEGfiles,32,224,226,423jsmintool,29jumboframes,400—401KKeepAlive,108keep-alives,HTTP,144kernelcaching,Windows,104—109enablingfordynamiccontent,105—107limitations,104—105performancecomparison,107—109keylookups,285—286KeyPerformanceIndicators(KPIs),436keySeedargument,92LLACP(LinkAggregationControlProtocol),401LanguageIntegratedQuery(LINQ),303LASTPERIODS()function,367laterequests,26latency,DNSserversand,404lazywriterthread,265Lazywrites/seccounter,SQLserver,343LDFfiles,264leafdata,defined,377leagues,418—419leveragecodeanalysistools,418LIKEclause,316linkaggregation,401LinkAggregationControlProtocol(LACP),401tag,63links,usingtogatepagerequests,40—41LINQ(LanguageIntegratedQuery),303liquidlayout,65Load()method,242—243loadbalancers,403—404loadtest,167—170load-balancedarchitecture,129LoadControlState()method,overriding,299loadingprocess,webpage,7LoadPageStateFromPersistenceMediummethod,84—85Lock()method,117lockescalation,configuring,314—315lockstatement,180,187locking,186—187LogParsertool,10,134—135LoggedIn()method,99logging,backgroundthreadfor,181—186logicalreads,289Login()method,97LoginReferenceobject,98LoginServiceobject,98LosFormatterserializer,84losslessimages,423MM2testingphase,414MAC(messageauthenticationcode),79—80MachFirstflag,237—238maintainabilitygoal,3managedHandlersetting,238ManualResetEventobject,299,301masterpages,201—204MasterPageFileproperty,202—204maximumtransmissionunit(MTU),16,400MD5algorithm,79MDBF(MobileDeviceBrowserFile),213INDEX460MDDBs(multidimensionaldatabases),351—362calculatedmember,360—361creatingcube,357datasourceview,353—356defined,436deployingandtesting,361—362itemsandusersdimensions,360overview,349—350RDBMSschema,351—353timedimension,357—359MDFfiles,264MDX(MultidimensionalExpressions),350—351,362—369,436MDXqueriesexample,362—369meantimebetweenfailure(MTBF),399meantimetoresolution(MTTR),minimizing,408measuregroups,377,437measures,defined,357,436memorymanagement,9,264—265messageauthenticationcode(MAC),79—80MESSAGETYPEobject,320tag,35MethodNameproperty,112MicrosoftExpressionWebcostof,10HTMLoptimization,35—36MicrosoftOffice,costof,11MicrosoftTerraServersystem,173MicrosoftVelocity,191mirroring,344—345,395MLC(multilevelcell)NANDmemory,399MobileDeviceBrowserFile(MDBF),213MobilePersisterclass,244modifiedbuffers,265modulofunction,193MOLAP(multidimensionalOLAP)mode,SSAS,377,437monitoringbenefitsof,9servers,408—409move()function,54MozillaFirefox.
SeeFirefoxMSFAgileprocess,413MTBF(meantimebetweenfailure),399MTTR(meantimetoresolution),minimizing,408MTU(maximumtransmissionunit),16,400multidimensionaldata,defined,437multidimensionaldatabases.
SeeMDDBsMultidimensionalExpressions(MDX),350—351,362—369,436multidimensionalOLAP(MOLAP)mode,SSAS,377,437multilevelcell(MLC)NANDmemory,399multipleasynctasks,executingfromsinglepage,170—172multipleresultsets,279—281usingSqlDataAdapterandDataSet,281usingSqlDataReader.
NextResult()method,279—281multiserverenvironment,speedingupdeployment,407Nnamedcalculations,355NativeCommandQueuing(NCQ),391NDFfiles,264NEARkeyword,319.
NETFramework,costof,10.
NETgarbagecollector(GC),121—122networkconnectionsandinitialHTTPrequest,14—16webpageloadingprocess,7networkdesign,400—401jumboframes,400—401linkaggregation,401networkinterface,enablingjumboframeson,401networkloadbalancing(NLB),404networkoptimizations,19—21NewProcessMatchingCriteriadialogbox,WSRM,132NewResourceAllocationPolicydialogbox,WSRM,133NewSilverlightApplicationdialog,VisualStudio,56NEWSEQUENTIALID()method,287NHibernatesystem,303,431NICteaming,401NIDvalue,95NLB(networkloadbalancing),404nonclusteredindexes,290—292,430NONEMPTY()function,367NotImplementedExceptionexception,256NTFSfragmentation,minimizing,433N-tierarchitecture,422INDEX461Oobjectcaching,ASP.
NET,117—122databasedependencies,120—121file-baseddependencies,119—120objectsusedbymorethanonepagerequest,118—119objectsusedonlybycurrentrequest,117—118objectswithglobalscopeandindefinitelifetime,117usingWeakReferenceobject,121—122objectdownloadorder,17ObjectRelationalModel(ORM),303—304ObjectDataSourcecontrol,297—298Office,costof,11OLAP(OnlineAnalyticProcessing),437OLTP(OnlineTransactionalProcessing),398,437OnConfigChange()eventhandler,335one-clickattacks,80OnEvent-stylemethods,298OnInit()method,298OnlineAnalyticProcessing(OLAP),437OnlineTransactionalProcessing(OLTP),398,437OnLoadmethod,299,429OnPageIndexChangingeventhandler,296OnPreRender()eventhandler,252OnPreServerRequestHeaders()method,139operationsgoal,3optimization,3—4,201—227browser-specificcode,212—220browserproviders,218—219cachingbrowser-specificpages,215—216cloaking,220controladapters,216—218propertyprefixes,214—215Request.
Browserobject,213—214dynamicallygeneratingJavaScriptandCSS,220—223accessingASP.
NETcontrols,222—223exampleof,221—222imageresizing,224—226masterpages,201—204multipledomainsforstaticfiles,223—224overview,201theme,208—211example,210—211precachingthemedimages,211settingdynamically,208—209skins,208staticfiles,208themableproperties,210URL,144—149rewriting,146—149virtualdirectories,145usercontrol,204—207exampleof,205—207placinginDLLs,207registeringandusing,207OptimizeHTMLmenu,ExpressionWeb,35—36ORM(ObjectRelationalModel),303—304outputcachingASP.
NET,110—117cachevalidation,116—117cachingpagefragmentswithusercontrols,111databasedependencies,113—115disabling,112removingitemsfromoutputcache,113substitutioncaching,112varyingoutputcache,115—116IIS7,109—110OutputCachedirective,76—77,105,109,111,114—116,143PP0(Priorityzero)bug,415P1bugs,415P2bugs,415P3bugs,415P3P(PlatformforPrivacyPreferences)value,95,237P4bugs,415pageadapters,242—244PageAdapterclass,244PageStatePersisterclass,242—243Pagebaseclass,241—242pagefragments,cachingwithusercontrols,111pagelifecycle,ASP.
NET,163—164Pagelifeexpectancycounter,SQLServer,343pageparsing,16—17pageresourcesnewresourcerequests,16—17order,17—18reducingnumberof,27—28reordering,17—18pagesplits,294Page_Load()method,144,207Page_Loaded()method,99INDEX462Page_PreInit()function,204,232PageAsyncTaskconstructor,166,170,172,300page-at-a-timedata,precachingof,283PageIndexChangingeventhandler,299Page.
IsPostBackflag,257tag,296PageViewBatchSizeargument,236PageViewsclass,302pagingdata.
Seedatapagingparallelobjectdownloads,20—23parallelism,22—23parameterizedcommandstrings,271—273parentID,212,214parityinformation,RAID5,396PartialCachingattribute,207partitionfunction,310—311partitionresolver,194—196partitionscheme,311partitionsize,equal,395PartitionStorageSettingsdialogbox,SSAS,377—378partitioningdata.
SeedatapartitioningPATHindex,309pathproperty,87—88Patternfield,IISManager,147PCIebusbandwidth,399.
pdb(symbol)files,259perfmon,386,389performancedefined,2differencefromscalability,2managementviewof,4perceived,8tuning,159userexperience,5performancecounters,386,409PerformanceMonitorUsersgroup,389PerformTask()method,328permanentcookies,188permanentredirects,249—250persistence,cookie,87Photoshop.
SeeAdobePhotoshopphysicalreads,289PlatformforPrivacyPreferences(P3P)value,95,237plentyoffish.
com,5PLT1,37,39,42,222PLT2,37,39,42,222PNGfiles,32,423portfiltering,403porttrunking,401POSTrequests,52postback,avoidingredirectsafter,258Pragmaheader,139precaching,61—63approach,282CSSandJavaScript,62—63forms-baseddata,282images,62page-at-a-timedata,283queries,282themedimages,211PreRenderevent,171—172,299PreRequestHandlerExecuteevent,209,232PreSendRequestHeadersevent,138primarykey,289PRIMARYXMLINDEXobject,308principles,8—10architectural,8secondarytechniques,9—10prioritizingtasks,4Priorityzero(P0)bug,415privacypolicy,compact,94—95Privacytab,IE,94proactivecaching,377—381cachingmodes,378—381datastorageoptions,377overview,350proactivemonitoring,409processingcubes,379—380ProcessorTimecounter,SQLServer,343ProcessRequest()method,239ProductGroupproduct,413profiles,cache,76—77projectphasesandmilestones,414proofsofconcept,304PROPERTYindex,309propertyprefixes,browser-specific,214—215prototyping,304proxies,cookieswith,102—103proxycaching,101—103managingdifferentversionsofsamecontent,103usingCache-ControlHTTPheader,102—103proxyservers,webpageloadingprocess,7QQualityAssurance(QA),405quality-basedexitcriteria,414query()clause,307INDEX463queryandschemaoptimization,285—294indexes,285—294addingclustered,288—290addingnonclustered,290—292creatingcovered,292—293examplewithnone,287—288fragmentation,293—294guidelines,286—287performanceissues,286queryoptimizationguidelines,294—295QUEUEobject,320—322QueuePageView()method,183QueueUserWorkItem()method,179RRAIDoptions,395—398RAID0andstripesize,395RAID1,395RAID3,396RAID5,396RAID6,396RAID10,396recommendations,396—398RAM,122,408Randomclass,193randomI/Os(IOPS)persecond,391—394RDBMS(RelationalDatabaseManagementSystem),350—353,437readoverhead,distributedcaching,123readthroughput,395reader.
NextResult()method,281ReaderWriterLockclass,186—187read-heavyworkloads,431readingcookies,90—91ReadOnlyflag,389READONLYparmeter,276read-onlyservers,scaling,341—342RECEIVEobject,322recyclingAppPools,129RedirectPermanent()method,250redirects,249—250avoidingafterpostback,258conventional,249HTTP,135—136permanent,249—250usingServer.
Transfer()method,250refactoringcode,418Refreshlink,40Registerdirective,211RegisterAsyncTask()method,166registeringHttpModuleinweb.
config,238PageAdapterobject,244usercontrols,207RegisterRequiresControlState()method,298RegObj()function,223regressions,identifying,417reimagingserver,407RelationalDatabaseManagementSystem(RDBMS),350—353,437relationalOLAP(ROLAP)mode,SSAS,377,438ReleaseReaderLock()method,187ReleaseRequestStateevent,197RemoveOutputCacheItem()method,113removingETagheader,138—139itemsfromoutputcache,113serverheader,137—138X-Aspnet-Versionheader,139X-Powered-Byheader,137Render()method,164,251Renderphase,216RenderAttributes()method,247renderingspeed,improving,60—61RenderTableproperty,218reportservers,defined,437requesthandlers,130Request.
Browserobject,213—214,428RequestInfoobject,181,233,236requestingobjectsafterrestofpage,26request-processingpipeline,130—131resizingimages,34,224—226resolvedbugs,415ResolvePartition()method,195ResolveUrl()method,211ResourceGovernorfeature,336—340backgroundthreads,283configuration,336—339executingprecachingcommand,282testing,339—340ResourceGovernorManagementdialogbox,SSMS,339responsebuffer,flushing,250—255chunkedencoding,254—255code-behind,251—252markup,251packettrace,252—254Response.
IsClientConnectedflag,258—259,430ResponseThrottler-InitialSendSizevariable,154ResponseThrottler-Ratevariable,154INDEX464resultsets,multiple,279—281usingSqlDataAdapterandDataSet,281usingSqlDataReader.
NextResult()method,279—281reusablecontent,avoidingregenerating,71reverseloadbalancing(RLB),404RewritePath()method,245—246rewritingURLs,146—149,244—246rgb()function,48RijndaelManagedobject,92RLB(reverseloadbalancing),404robots.
txt,managingtrafficusing,150—151ROLAP(relationalOLAP)mode,SSAS,377,438rollingupgrades,406rolloverimageslaterequests,26transparencyasalternativeto,31round-trips,reducing,8,71routers,usingasalternativetohardwarefirewall,403ROW_NUMBER()function,295Ssaltstring,92SANs(storagearraynetworks),398SASdrive,397SATAinterfaces,399Save()method,242—243SaveforWebcontrolpanel,Photoshop,32—33SaveControlState()method,299SavePageStateToPersistenceMediummethod,84—85scalabilitydefined,2differencefromperformance,2distributedcaches,123effectofthreadson,161—163ofexistingsynchronouspages,170sessionstatesupport,191—197configuringcustomsessionIDmanagerandpartitionresolver,196customsessionIDmanager,193—194partitionresolver,194—195scalingout,192scalingup,192testingnewcode,196—197scalableshareddatabases,341SCD(slowlychangingdimension),383schemaoptimization.
SeequeryandschemaoptimizationSCOM(SystemCenterOperationsManager),11,409,434,26includefilehandlingeliminatingCSSround-tripsforfirstpageview,37—39HTMLavoidingoptimizationtechniquesthatviolatestandards,37optimizers,35—36increasingparallelismbyqueuingresourcesbeforefiles,22—23minimizingnumberoffiles,23—25avoidingdocument.
write(),23—24reorderingfilesthatcan'tbemodified,25requestingobjectsafterrestofpage,26,26server-sidealternatives,26—34downloadingless,27imageoptimization,30—34maximizingcompressibility,30minimizingHTML,28—30reducingnumberofresourcesperpage,27—28websiteiconfile,34—35ScriptableMemberattribute,58SCSIdrive,397search,full-text,316—319creatingfull-textcatalogandindex,316—317full-textqueries,317—318obtainingsearchrankdetails,318searchenginescloaking,220managingloadfrom,150—152Silverlightand,60secureproperty,90segregatingapplications,134SELECTCOUNT(*)query,297,315SELECTstatement,279SelectCountMethodcontrol,297SelectMethodcontrol,297Semaphoreobject,182sequentialI/Os(IOPS)persecond,391—394serializationrequest,169session,198oftasks,186ServerExplorer,VisualStudio,388serverheader,removing,137—138INDEX465servermonitoring,408—409SERVER_SOFTWAREvariable,144,237Server.
Transfer()method,250,429servicebroker,319—323avoidingpoisonedmessages,323enablingandconfiguring,320—321sendinge-mailvia,323—331creatingbackgroundworkerthread,324—325readingandprocessingmessages,325—328results,331webformtoqueuemessage,328—330storedproceduretoreceivemessages,322tosendmessages,321testingexample,323SERVICEobject,320—321sessionIDs,81,188—189,193—194,196—197sessionstate,187—198alternativesto,199fine-tuning,197full-customsessionstate,197—198InProcmode,189ReadOnlymode,190—191scalingsessionstatesupport,191—197configuringcustomsessionIDmanagerandpartitionresolver,196customsessionIDmanager,193—194partitionresolver,194—195scalingout,192scalingup,192testingnewcode,196—197selectivelyenabling,190—191sessionIDs,188—189sessionserialization,198storingusingSQLServer,189—190usingStateServer,189SessionIDManagerclass,193sessionIDManagerTypeproperty,196sessions,defined,86Set()method,301SETNOCOUNTON,295SetCacheabilityobject,102Set-Cookieheader,38,44,85—86SetLength()method,177,393sets,369SetServerNoCaching()method,102setTimeout()method,40—41SetValidUntilExpires()method,117SetVaryByCustom()method,103,425SHA-1algorithm,79showstopperbugs,415silenceinterval,379,SSASsilenceoverrideinterval,379,SSASSilverlight,55—60addingrepetitivestrings,424avoidingfullpageloads,9buildingHTMLcontrols,55—58callingintofromJavaScript,58—59cookiesreading,91setting,86—90costof,11generatingrepetitiveHTML,424isolatedstorage,96—101single-levelcell(SLC)NANDmemory,399sitemaps,151—152SiteSettingsobject,99—100skins,208SLC(single-levelcell)NANDmemory,399slices,defined,350slicingtool,Photoshop,34slowstartfeature,16slowlychangingdimension(SCD),383SMTPserver,sendinge-mailviaServiceBroker,323—324softwaredevelopmentprocess,establishing,412solidstatedisks(SSDs),399sp_spaceusedcommand,408spacerGIFs,27SpecifyContenttoTracedialogbox,IISManager,155SQLCLR,346SQLinjection,402SQLProfiler,294SQLServer.
Seealsoqueryandschemaoptimizationanalysisservices,349—384ADOMD.
NET,369—373MDDBexample,351—362MDXqueriesexample,362—369overview,350—351proactivecaching,377—381stagingdatabase,381—383updatingcubewithSSIS,374—377commandbatching,267—273INDEX466buildingparameterizedcommandstrings,271—273usingSqlDataAdapter,267—271costof,11dataaccesslayer,283—285datachangenotifications,331—336exampleof,333—336queryrestrictions,331—333datapaging,295—303commontableexpressions,295—296exampleof,296—303datapartitioning,310—316addingindexandconfiguringlockescalation,314—315archivingolddata,315—316generatingtestdata,311—314partitionfunction,310—311partitionscheme,311dataprecaching,281—283approach,282offorms-baseddata,282ofpage-at-a-timedata,283full-textsearch,316—319creatingfull-textcatalogandindex,316—317full-textqueries,317—318obtainingsearchrankdetails,318memorymanagement,264—265organization,264performanceimpact,265readsandwrites,264—265multipleresultsets,279—281usingSqlDataAdapterandDataSet,281usingSqlDataReader.
NextResult()method,279—281objectrelationalmodels,303—304performancetips,345—346ResourceGovernorfeature,336—340configuration,336—339testing,339—340scalingupversusscalingout,340—344identifyingsystembottlenecks,343—344scalingout,341—342scalingup,340—341servicebroker,319—323avoidingpoisonedmessages,323enablingandconfiguring,320—321sendinge-mailvia,323—331storedproceduretoreceivemessages,322storedproceduretosendmessages,321testingexample,323storedprocedures,266—267storingsessionstateusing,189—190transactions,273—279writethroughput,123XMLcolumns,304—309basicXMLqueries,307creatingexampletable,306—307modifyingXMLdata,307—308tipsregarding,309XMLindexes,308—309XMLschema,305—306SQLServerandWindowsAuthenticationmodeoption,SSMS,337SQLServerExpress,123,165SQLServerFeaturePack,11,369SQLServerIntegrationServices(SSIS),374—377SQLServerManagementStudio(SSMS),276,350SQLServerReportingServices(SSRS),350SqlCacheDependencyclass,114,121,331SqlCommandobject,121,173,268SqlConnectionobject,173,274sqlConnectionStringproperty,190SqlDataAdapterobject,121,267—271,304SqlDataReadercommand,301SqlDataReaderobject,304SqlDependencyclass,114—115,331,422sql:variable()function,307SSDs(solidstatedisks),399SSIS(SQLServerIntegrationServices),374—377SSMS(SQLServerManagementStudio),276,350SSRS(SQLServerReportingServices),350stagingdatabases,381—383,398,438stagingenvironments,405stale(invalid)content,73starschema,defined,438starsnowflakeschema,defined,438stateinformation.
Seesessionstatestatemanagement,optimizing,71stateobject,171StateServerobject,189staticcontent,73—75,103staticfilesmultipledomainsfor,223—224themes,208storagearraynetworks(SANs),398storedproceduresINDEX467overview,266—267toreceivemessages,322tosendmessages,321supportforautogeneratingunitteststubsfor,417storingsessionstateusingSQLServer,189—190usingStateServer,189Streaminterface,255Strictdialect,61,201—202stripsize,395StyleSheetThemeproperty,208—209,232submitbuttons,usingtogatepagerequests,39—40substitutioncaching,112substitutioncontrols,112SUM()function,286,368switchingpartitions,310,315symbol(.
pdb)files,259SYNfloods,403SYNpackets,15—16synchronousdatabasecommands,283synchronousdatabasewrites,avoiding,9synchronouspages,165synchronousthreads,390systemarchitecture,defining,412systembottlenecks,identifying,343—344SystemCenterOperationsManager(SCOM),11,409,434Ttablepartitioning,310tablescan,286TABLETYPEARGUMENT,276tag,60tablelesslayout,64—66table-valuedparameters,276—279tagtransforms,247TAP(TechnicalAssistanceProgram),416TargetServerMemory(KB)counter,SQLServer,343TaskRequestclass,328TCPprotocolexchangepagerequests,14—15TeamFoundation,413,415TeamSystemDatabaseEdition,11TechnicalAssistanceProgram(TAP),416templates,custom,82—84temporarycookies,188TerraServersystem,173TestPatterndialogbox,IISManager,148testingindevelopmentprocess,415,417ResourceGovernorfeature,339—340textimages,27—28control,,98Themetheme,208—209[Themeable(false)]attribute,210themes,208—211exampleof,210—211precachingthemedimages,211settingdynamically,208—209skins,208staticfiles,208themableproperties,210third-partycookies,94threadwaitingtimes,minimizing,8ThreadAbortExceptionexception,186,249,327threadsapplicationthreadpool,165—179asynchronousfileI/O,176—177asynchronouspage,166—167asynchronouswebrequests,178—179asynchronouswebservices,173—176executingmultipleasynctasksfromsinglepage,170—172handlingtimeouts,172—173improvingscalabilityofexistingsynchronouspages,170loadtest,167—170synchronouspage,165ASP.
NETpagelifecycle,163—164backgroundworkerthreads,179—186backgroundthreadforlogging,181—186taskserialization,186effectonscalability,161—163lockingguidelinesandusingReaderWriterLock,186—187three-tierarchitecture,422throttlingbandwidth,152—154tiers,3,422tildecharacter(~),319tilingimages,31timetolive(TTL)value,405timeoutproperty,190timeouts,handling,172—173TimeSpanobject,119TOPCOUNT()function,366TotalServerMemory(KB)counter,SQLServer,344trafficmanagment,150—154INDEX468bandwidththrottling,152—154sitemaps,151—152usingrobots.
txt,150—151Transactionsobject,273TransactionScopeobject,273—279explicitBEGINandCOMMITTRANSACTIONstatements,275table-valuedparameters,276—279Transfer()method,258Transitionaldialect,60transparency,asalternativetorolloverimages,31transparentproxy,defined,7triggers,avoiding,294T-SQLqueries,362—363TTL(timetolive)value,405tuples,367two-tierserverarchitecture,422TypeConverter,minimizingserialization,84UUA-CPUheader,44UltraDNSservice,404ultra-fast,meaningandimportanceof,2—5ultra-scalable,meaningandimportanceof,2—5UNC(UniversalNamingConvention)files,104UNIQUEIDENTIFIERobject,286uniquenesscollisions,avoiding,293unittesting,417UniversalNamingConvention(UNC)files,104UnLock()method,117Update()method,271Updatethecacheperiodicallyoption,SSAS,380updatingSilverlightapplications,101uploadingless,43—45section,141—142URLscasesensitivity,18,205withcommonprefixes,43consistent,136optimizing,144—149rewriting,244—246fromHttpModule,245—246modifyingformstouserewrittenURLs,246overview,146—149virtualdirectories,145usercontrols,204—207exampleof,205—207placinginDLLs,207registering,207userexperience,5userfeedback,416userperspective,monitoring,409User-agentfield,150regularexpression,212User-Agentstring,44,212—213usingstatement,180,236Vv1IDENTITYcolumn,288Validate()method,194validation,cache,116—117validationKeyobject,80value()clause,307VALUEindex,309Vary:*header,103Vary:Accept-Encodingheader,103Vary:Cookieheader,103VaryByContentEncodingproperty,143VaryByControlfunction,205—206VaryByCustomfunction,115—116,204,215,222,426VaryByParamvalue,76Velocitytechnology,191verticalscaling,341__VIEWSTATEfield,79,81ViewStateobject,protectingdataintegrityof,78—85minimizingsize,81—82storingonserver,84—85usesof,80—81usingcustomtemplateinVisualStudio,82—84ViewStateUserKeyproperty,80—81virtualdirectories,145virtualprivatenetwork(VPN)endpoint,403visibleproxies,defined,7,101VisualStudiobuildingSilverlightapplications,56—57costof,11hostingSilverlightcontrol,100masterpages,203usingcustomtemplatesin,82—84usingjsmintoolwith,29VisualStudioWebExpress,11VPN(virtualprivatenetwork)endpoint,403INDEX469WW3SVC1file,158w3wp.
exeprocess,127Wait()method,184waitforcommand,173WaitOne()method,302WCATtool,167WCF(WindowsCommunicationsFoundation),85,96—100WDS(WindowsDeploymentServices),407WeakReferenceobject,121—122,426wearleveling,399webarchitecture,5—6webcaches.
SeeproxycachingWebDeploymentProjectsadd-in,29WebDeploymentProjects,cost,11webgardens,127—129webpages,loadingprocess,7webproxies,101—103webrequests,asynchronous,178—179webservercache,103—122ASP.
NETobjectcaching,117—122databasedependencies,120—121file-baseddependencies,119—120objectsusedbymorethanonepagerequest,118—119objectsusedonlybycurrentrequest,117—118objectswithglobalscopeandindefinitelifetime,117usingWeakReferences,121—122ASP.
NEToutputcaching,110—117cachevalidation,116—117cachingpagefragmentswithusercontrols,111databasedependencies,113—115disablingoutputcaching,112removingitemsfromoutputcache,113substitutioncaching,112varyingoutputcache,115—116IIS7outputcaching,109—110Windowskernelcaching,104—109enablingfordynamiccontent,105—107limitations,104—105performancecomparison,107—109webservices,asynchronous,173—176websiteiconfile,34—35web.
configfileconfiguringcompressionusing,142—143registeringcontrols,207registeringHttpModulein,238insubdirectories,159WebControlAdapterobject,217WelcomeBacksampleapplication,96—100HTMLanduser'sexperience,100isolatedstorageandcallingWCFservice,98—100WCFservice,97XAMLmarkup,97—98WHEREclause,286,295,364whitespacefiltering,255—257,429wildcardsfull-textsearch,319XMLqueries,309WindowsCommunicationsFoundation(WCF),85,96—100WindowsDeploymentServices(WDS),407Windowseventlogs,monitoring,409WindowsFirewall,403Windowskernelcaching,104—109enablingfordynamiccontent,105—107limitations,104—105performancecomparison,107—109WindowsPresentationFoundation(WPF),55WindowsServer,costof,11WindowsSystemResourceManager(WSRM),131—134,390WindowsVista,costof,11WindowsAuthenticationmodule,159Wireshark,costof,11workitem,queuingtobackgroundthread,283WorkItemclass,182workItemLockObjectobject,182WORKLOADGROUPobject,338WPF(WindowsPresentationFoundation),55Write()method,255—256writethroughput,123,SQLServerWriteAttribute()method,248write-mostlyservers,scaling,342WSRM(WindowsSystemResourceManager),131—134,390WWWServerentry,IISManager,156XXAMLmarkup,97—98.
xapfiles,101X-Aspnet-Versionheader,139XMLcolumns,304—309basicXMLqueries,307creatingexampletable,306—307INDEX470miscellaneousXMLquerytips,309modifyingXMLdata,307—308XMLindexes,308—309XMLschema,305—306XMLfiles,sitemaps,151XMLAlanguage,350XmlHttpcontrol,53—54x:Nameattribute,98X-Powered-Byheader,137XQuery,304YYSlow,cost,11Zzerobugbounce(ZBB),414.
zipfiles,limitingdownloadspeedof,153—154