SQL Server Review

I use it to fine tune my procedures and functions

What is our primary use case?

I use SQL Server to optimize SQL queries and find the estimated cost of my queries. 

I also use it to fine tune my procedures and functions.

How has it helped my organization?

  • SQL Server has maintained my database problem in an arranged manner.
  • SQL Server Profiler makes finding and debugging easy.
  • Support for third-party tools, like SQL Search.

What is most valuable?

  • SQL Server Profiler: Know exactly which procedures and functions are being called and how much read and write they are taking.
  • Tuning Advisor: It suggests where to add indexes and from where to remove them. It works like an adviser.
  • Storage capability
  • Debugger: The debugger tool can execute code step-by-step.

What needs improvement?

  • Third-party services from Redgate should be built-in to it, like SQL Search.
  • Debugging from the debugger tool functionality should be enhanced.

For how long have I used the solution?

Three to five years.

What do I think about the stability of the solution?

No stability issues.

What do I think about the scalability of the solution?

No scalability issues.

How is customer service and technical support?

It is good.

Which solutions did we use previously?

I have been using SQL Server from the start.

How was the initial setup?

It was straightforward.

What about the implementation team?


What was our ROI?

It is good.

What's my experience with pricing, setup cost, and licensing?

The setup cost is high, but it will return every penny.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email