{"id":1660,"date":"2012-05-21T15:13:00","date_gmt":"2012-05-21T15:13:00","guid":{"rendered":"http:\/\/cloudcomputing.sys-con.com\/node\/2280870"},"modified":"2012-05-21T15:13:00","modified_gmt":"2012-05-21T15:13:00","slug":"cloudtip-14-can-i-get-profile-information-from-sql-azure","status":"publish","type":"post","link":"https:\/\/icloud.pe\/blog\/cloudtip-14-can-i-get-profile-information-from-sql-azure\/","title":{"rendered":"CloudTip #14 &#8211; Can I Get Profile Information from SQL Azure?"},"content":{"rendered":"<p>Your application is running slow. You need to find out what\u2019s going on. If you\u2019ve used SQL Profiler on a local database you might be familiar with how you can capture a trace of database activity and use it to figure out where your resources are going. The visibility makes it MUCH easier to tune a database than sorting thru a bunch of code. The question is, what do you do when you\u2019re moving an app to the cloud?<br \/>\nIf you\u2019ve wondered how you can get Profile information from SQL Azure, the new online management portal for SQL Azure has been updated with design, deployment, administration and tuning features built in. The Overview screen provides quick links to the different areas of the portal, as well as easy links to help information from msdn online. You can get to the portal either by going to the Windows Azure management portal on <a href=\"http:\/\/windows.azure.com\" title=\"http:\/\/windows.azure.com\">http:\/\/windows.azure.com<\/a> and after signing in going to the database section and clicking Manage, or simply browsing to your database name \u2013 https:\/\/<myserver>.database.windows.net where you substitute your database server\u2019s name for <myserver>.<\/p>\n<p><a href=\"http:\/\/cloudcomputing.sys-con.com\/node\/2280870\" >read more<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Your application is running slow. You need to find out what\u2019s going on. If you\u2019ve used SQL Profiler on a local database you might be familiar with how you can capture a trace of database activity and use it to figure out where your resources are go&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1660","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/1660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/comments?post=1660"}],"version-history":[{"count":0,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/1660\/revisions"}],"wp:attachment":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/media?parent=1660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/categories?post=1660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/tags?post=1660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}