prikaz prve stranice dokumenta Napredni načini za optimizaciju performansi na SQL serveru
  Download
PDF 1.47 MB
master's thesis
Napredni načini za optimizaciju performansi na SQL serveru
2022. urn:nbn:hr:200:723315
Kupanovac, Leon
Josip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
Department of Computer Engineering and Automation
Chair of Computer Engineering

Cite this document

Kupanovac, L. (2022). Napredni načini za optimizaciju performansi na SQL serveru (Master's thesis). Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek. Retrieved from https://urn.nsk.hr/urn:nbn:hr:200:723315

Kupanovac, Leon. "Napredni načini za optimizaciju performansi na SQL serveru." Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2022. https://urn.nsk.hr/urn:nbn:hr:200:723315

Kupanovac, Leon. "Napredni načini za optimizaciju performansi na SQL serveru." Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2022. https://urn.nsk.hr/urn:nbn:hr:200:723315

Kupanovac, L. (2022). 'Napredni načini za optimizaciju performansi na SQL serveru', Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, accessed 25 April 2024, https://urn.nsk.hr/urn:nbn:hr:200:723315

Kupanovac L. Napredni načini za optimizaciju performansi na SQL serveru [Master's thesis]. Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek; 2022 [cited 2024 April 25] Available at: https://urn.nsk.hr/urn:nbn:hr:200:723315

L. Kupanovac, "Napredni načini za optimizaciju performansi na SQL serveru", Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, Osijek, 2022. Available at: https://urn.nsk.hr/urn:nbn:hr:200:723315

Please login to the repository to save this object to your list.
Metadata
TitleNapredni načini za optimizaciju performansi na SQL serveru
Title (english)Advanced approaches to performance tuning in SQL server
AuthorLeon Kupanovac
MentorIvan Aleksi (mentor)
Committee memberIvan Aleksi (predsjednik povjerenstva)
Committee memberTomislav Matić (član povjerenstva)
Committee memberIvica Lukić (član povjerenstva)
GranterJosip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
(Department of Computer Engineering and Automation)
(Chair of Computer Engineering)
Osijek
Defense date and country2022-07-14, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Information Systems
Abstract
U današnjem modernom svijetu i ubrzanom životu potrebno je što prije doći do željenih informacija, kako bi se povećala sama produktivnost. Upravo zbog toga postoji mnogo načina kako bi što prije došli do određenih informacija. Napredni načini za optimizaciju performansi u SQL programu nam omogućuju brži i efikasniji pristup željenim informacijama. U ovom radu opisana je arhitektura indeksa, vrste, te sam rad. Također je opisano ubrzanje zahtjeva pomoću statistike čekanja koja je implementirana u sam SQL Server. U radu se govori i o savjetima, odnosno njihovoj vrsti te kada ih primijeniti. Također opisan je plan izvršavanja te pojedine njegove pojedine komponente. Izvršeno je poboljšanje kroz tri upita. Početno izvršavanje trajalo je oko desetak minuta, poboljšanjem upita to vrijeme svedeno je na gotovo par sekundi.
Abstract (english)
In today's modern world and fast-paced life, it is necessary to get the desired information as soon as possible, in order to increase productivity itself. This is exactly why there are many ways to get certain information as soon as possible. Advanced Approaches to performance tuning in sql server engine allow us to access the desired information faster and more efficiently. This paper describes the architecture of the index, types, and how they work. It also describes how to speed up requests using the wait statistics implemented in SQL Server. The paper also talks about hints, i.e. their type and when to apply them. The execution plan and its individual components are also described. An improvement was made through three queries. The initial execution took about ten minutes, by improving the query, that time was reduced to a couple of seconds.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:200:723315
Study programmeTitle: Graduate University Study Programme in Electrical Engineering; specializations in: Communications and Informatics, Power Engineering
Course: Communications and Informatics
Study programme type: university
Study level: graduate
Academic / professional title: magistar/magistra inženjer/inženjerka elektrotehnike (magistar/magistra inženjer/inženjerka elektrotehnike)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2022-09-07 09:08:09