{"id":"https://openalex.org/W126096918","doi":"https://doi.org/10.1007/978-1-4302-6742-3_5","title":"Creating a Baseline","display_name":"Creating a Baseline","alternate_titles":[],"publication_year":2014,"publication_date":"2014-08-27","ids":{"openalex":"https://openalex.org/W126096918","doi":"https://doi.org/10.1007/978-1-4302-6742-3_5","mag":"126096918"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-6742-3_5","doi":"https://doi.org/10.1007/978-1-4302-6742-3_5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_5","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2479662415","display_name":"SQL Server Query Performance Tuning","relationship":"volume"}],"lineage":["https://openalex.org/W126096918","https://openalex.org/W2479662415"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064569577","display_name":"Grant Fritchey","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Grant Fritchey","raw_affiliation_strings":["MA, US","Grafton, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MA, US","institution_ids":[]},{"raw_affiliation_string":"Grafton, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5064569577"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"57","last_page":"68"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.0007999999797903001,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.0005000000237487257,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/performance-baseline","display_name":"performance baseline","score":0.6019999980926514},{"id":"https://openalex.org/keywords/system-bottlenecks","display_name":"system bottlenecks","score":0.6769999861717224},{"id":"https://openalex.org/keywords/automatic-monitoring","display_name":"automated monitoring","score":0.6919999718666077},{"id":"https://openalex.org/keywords/memory-performance","display_name":"memory performance","score":0.5879999995231628},{"id":"https://openalex.org/keywords/disk-performance","display_name":"disk performance","score":0.8690000176429749},{"id":"https://openalex.org/keywords/processor-performance","display_name":"processor performance","score":0.8450000286102295},{"id":"https://openalex.org/keywords/windows","display_name":"windows","score":0.5809999704360962}],"concepts":[{"id":"https://openalex.org/C12725497","wikidata":"https://www.wikidata.org/wiki/Q810247","display_name":"Baseline (sea)","level":2,"score":0.9536987543106079},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6601434946060181},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.5793074369430542},{"id":"https://openalex.org/C2780428219","wikidata":"https://www.wikidata.org/wiki/Q16952335","display_name":"Cover (algebra)","level":2,"score":0.5010240077972412},{"id":"https://openalex.org/C193429382","wikidata":"https://www.wikidata.org/wiki/Q232405","display_name":"Metric system","level":2,"score":0.41312357783317566},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.16144493222236633},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0968102216720581},{"id":"https://openalex.org/C111368507","wikidata":"https://www.wikidata.org/wiki/Q43518","display_name":"Oceanography","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C1276947","wikidata":"https://www.wikidata.org/wiki/Q333","display_name":"Astronomy","level":1,"score":0.0},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-6742-3_5","doi":"https://doi.org/10.1007/978-1-4302-6742-3_5","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_5","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W171388289","https://openalex.org/W7098230096","https://openalex.org/W2977034","https://openalex.org/W161859449","https://openalex.org/W2170294190","https://openalex.org/W7095957509","https://openalex.org/W7100458624","https://openalex.org/W2803522962","https://openalex.org/W6959727234","https://openalex.org/W2004976600"],"abstract_inverted_index":{"In":[0],"the":[1,17,20,38,41,46,107,119,126,132],"previous":[2],"three":[3],"chapters,":[4],"you":[5,68,98],"learned":[6],"a":[7,25,55,90],"lot":[8],"about":[9],"various":[10],"possible":[11],"system":[12,95],"bottlenecks":[13],"caused":[14],"by":[15,114,118],"memory,":[16],"disk,":[18],"and":[19,116,125],"CPU.":[21],"I":[22,48],"also":[23],"introduced":[24],"number":[26],"of":[27,37,43,45,93],"Performance":[28],"Monitor":[29],"metrics":[30,65],"for":[31,72],"gathering":[32,84],"data":[33],"on":[34],"these":[35],"parts":[36],"system.":[39],"Within":[40],"descriptions":[42],"most":[44],"counters,":[47],"referred":[49],"to":[50,54,62,79],"comparing":[51],"your":[52,64],"metric":[53],"baseline.":[56],"This":[57,104,121],"chapter":[58,105],"will":[59],"cover":[60],"how":[61,78],"gather":[63],"so":[66,97],"that":[67,70],"have":[69,101],"baseline":[71,88],"later":[73],"comparison.":[74],"I\u2019ll":[75],"go":[76],"over":[77],"configure":[80],"an":[81],"automated":[82],"method":[83],"this":[85],"information.":[86],"A":[87],"is":[89,123],"fundamental":[91],"part":[92],"understanding":[94],"behavior,":[96],"should":[99],"always":[100],"one":[102],"available.":[103],"covers":[106],"following":[108],"topics:":[109],"These":[110],"keywords":[111,127],"were":[112],"added":[113],"machine":[115],"not":[117],"authors.":[120],"process":[122],"experimental":[124],"may":[128],"be":[129],"updated":[130],"as":[131],"learning":[133],"algorithm":[134],"improves.":[135]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W126096918","counts_by_year":[],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-06-24T00:00:00"}
