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?

In-house.

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
Guest
Sign Up with Email