Navigation and service panel


Content

Posts tagged "SQL"

Database performance analysis - Part II

By Ernst Joss on 22. April 2015, No comments

Usually one might not bother about database for Sitcore websites, especially not when the „normal“ SQL guidelines are taken into account during setup of your SQL server. But there might be situation where you think that maybe your database could be the limiting factor for your website. In this cases it can be helpful to know a little bit more about the state of your database used.
In Part I I described some techniques how to identify queries for further analysis. This second Part will now talk about how further analysis for particular queries can happen.

read on
Categories  Tools  Troubleshooting Tags  SQL  diagnostics

Database performance analysis - Part I

By Ernst Joss on 13. April 2015, No comments

Usually one might not bother about databases for Sitcore websites, especially not when the "normal" SQL guidelines are taken into account during setup of your SQL server. But there might be situations where you think that maybe your database could be the limiting factor for your website. In this cases it can be helpful to know a little bit more about the state of your database used.

read on
Categories  Tools  Troubleshooting Tags  SQL  diagnostics

Sitecore Fast Queries nach SQL übersetzen

By Tobias Studer on 3. March 2014, No comments

In manchen Situationen kann es sehr nützlich sein, die SQL Queries zu sehen, welche aus Sitecore Fast Queries generiert werden. Dazu gibt es leider sehr wenige bis keine Informationen im Netz. Dadurch ist der LoquaciousDataProvider entstanden.

read on
Categories  Modules  Troubleshooting Tags  DataProvider  FastQuery  SQL  Log