Lesson Learned #143: (Spanish) – I’m not able to find where is the problem in my query

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

(English)

These last weeks we got several cases that our customers reported that they need to identify the query that is taking time and they are not able to find it. In this video recorded in Spanish we covered several techniques to identify it.

 

For example, in .NET we have the option to debug our application using instrumentation to know the time spent. You could use it in combination with StopWatch, Query Data, SQL Server Management Studio and the Portal. 

 

I hope that you could enjoy this video in spanish. This session was recorded in NetCoreConf event this last 2nd Oct 2020.

 

(Spanish)

Estas últimas semanas hemos tenidos casos de soporte que nuestros clientes solicitan identificar la query que está tomando mucho tiempo en ejecutarse. En este video en español vamos a revisar ciertos técnicas que nos permitirán encontrarlo. 

 

Por ejemplo, en .NET tenemos una opción para depurar nuestra aplicación usando la instrumentación que nos permite conocer los tiempos invertidos en cada proceso. Esto se puede usar en StopWatch, Query Data, SQL Server Management Studio, Portal, etc.

 

Espero que lo encuentres interesante. Esta session fue grabada en el evento NetCoreConf de este pasado 2 de Octubre 2020. 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.