I have lived many a days watching performance of SQL queries using SQL Profiler (Claims Inquiry??? - for people who knew about it) . Finding ways to improve the time taken and optimizing the same was a fun exercise; I always hate the idea of using SQL profiler, I always thought it was probably one of the worse Microsoft tools without good user interaction, I agreee that it was one of the powerful tools available to monitor SQL Server but not the best tool in terms of user interaction.
Anybody who feels the same way should try (free) tool SQL Heartbeat, it gives the information of your database in a visual way so it makes it easy to grasp the data.
Processes grow larger as they use more resources. Red balloons appear when locking occurs. Download it from: sqlsolutions
Prem's views on life, .net and software development (everything contained in one strongly typed weblog).
Showing posts with label SQL server 2005. Show all posts
Showing posts with label SQL server 2005. Show all posts
Friday, February 19, 2010
Tuesday, February 13, 2007
SQL Server 2005 Installation problem in Vista
I have been trying to install SQL Server 2005 in my vista ultimate edition, but it fails with the following error. "This program has known compatibility issues" and it's failing to install core server components.
It's really wierd if I can't install sql server 2005 properly in my system how do they expect it to be fixed by Service Pack2 ?
Subscribe to:
Posts (Atom)
Loading...