Interacting with other technology industry professionals and related websites an

Question

Interacting with other technology industry professionals and related websites and periodicals is necessary for networking and staying current on industry trends. Using an industry website such as one of those listed below, research a technology issue that interests you and find a relevant article about it that you can share. In your post, include a link to the article along with a summary of what you learned from reading it. Discuss how industry professionals could benefit from the article and apply it to their everyday work within the technology field.

1 PASS: http://www.sqlpass.org/aboutpass.aspx

2 Born to Learn: https://borntolearn.mslearn.net/

3 Oracle University: https://blogs.oracle.com/oracleuniversity/

Explanation / Answer

Answer)

Let's discuss the technical issues related to SQL.

When the TempDB is not configured properly then it affects the performance of the SQL Queries.

An optimal configuration of tempDB has to be made for ensuring that this repeated offender is not affecting the performance. One needs to check the trage flags 1117 and 1118 if enabled or not when using SQL Server 2016 or above as standards.

To check if the tempDB is configured then check the PAGELATCH _XX wait types which acts as an indicator of this contention.

Place these tempDB Files in the place which is considered as high speed disk and enable the IFI.

The second issue can be the index maintenance to be run on a frequent basis which is it has to be done on an index fragment basis as it would help to update the statistics.

The index provided might reduce the performance if not monitored and placed properly. For this a health check of such SQL Queries and procedures are much needed.

Industry professionals should follow a thorough monitoring and deep dive analysis to implement such queries to help the system performance grow.

Apologies for not providing any reference to this answer as it is against the Chegg policy.

Hope this answer useful. :)

Hit like if you find this answer helpful.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.