THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Azure » Development » Performance Tun... » SQL Server   (RSS)
  • Performance-Driven Development

    I was reading a blog yesterday about the evils of SELECT *. The author pointed out that it's almost always a bad idea to use SELECT * for a query, but in the case of SQL Azure (or any cloud database, for that matter) it's especially bad, since you're paying for each transmission that comes down the line. A very good point indeed. This got me to ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 11, 2010
  • Monitoring SQL Azure For Performance

    In SQL Server Azure, there are no Dynamic Management Views (DMVs) or Performance Monitor Objects and Counters that you can access, so you can’t run your standard performance monitoring that way. I suspect that as time goes on, SQL Azure will have some instrumentation, but for the time being, you’ll have to go with a different metric – round trip ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 22, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement