Does accessing SQL Server cluster node increase performance ?

I have developed a CRM application using .net and SQL server database.
This CRM database has attached to online CRM web application and online web reporting  application.
Also CRM database connected to more than 30 desktop application in the local computer  network.  The database has more than 30 GB size. Now my desktop users are reporting slowness in the application and when users accessing reporting model the application is very slow.
My SQL server configured in cluster node. So it has own virtual IP.  To overcome the slowness issue one of my SQL server  consultant suggest me to map the reporting application to cluster node. And he told me that it will work like a load balancing and your desktop application will work fine.

My questions is, if I  map the reporting application to the cluster IP , does it improve the performance ?
Varshini SAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PadawanDBAOperational DBACommented:
If it's a traditional failover cluster, those are active/passive and for availability only.  AlwaysOn availability groups allow you to use secondaries for read only workloads via Availabity Group Listeners.  I'm a little curious as to why you wouldn't have everything pointing to the vip, however, as if the cluster fails over, you wouldn't be pointing to the active node...

Edit: as to your original question, there's no reason pointing to a cluster vip for a failover cluster would increase your performance.  it's just an IP resource that gets failed over betwixt the nodes
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ZberteocCommented:
It is a good practice to put your reporting databases on a different machine than the one used for online applications. Sometimes reports have to run through a bunch of data and overload the server especially if the SQL code behind is poorly built or missing some indexes. Most of the time you can overcome the performance issue by building the right indexes and/or optimizing the code. Even so running a report could cause performance issues if it has to go through a lot of data.

Ideally you have to separate the reporting server from the application server. You can do this if you have a replication environment, a log shipping environment(however in this case you can experience connection interruptions while restoring the logs), always on configuration(2008 and up) where you can use the secondary node for reporting. In the case of active active classic cluster, you should point the reporting server to the second node but in this case the storage is still common so the impact is not that big.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Now my desktop users are reporting slowness in the application and when users accessing reporting model the application is very slow.
Usually reports are slow since they handle with a lot of data. You can boost the performance of reports by adding the right indexes to increase the speed of the queries.

To overcome the slowness issue one of my SQL server  consultant suggest me to map the reporting application to cluster node. And he told me that it will work like a load balancing and your desktop application will work fine.
That is so wrong. If you map to a physical node then it won't work if the active node is the other one. Also clusters doesn't act as load balance. Their purpose is to provide high availability.
As suggested above you can use AlwaysOn to accomplish something similar but for that you need SQL Server 2012 or 2014 Enterprise Edition.
0
Become an IT Security Management Expert

In today’s fast-paced, digitally transformed world of business, the need to protect network data and ensure cloud privacy has never been greater. With a B.S. in Network Operations and Security, you can get the credentials it takes to become an IT security management expert.

Varshini SAuthor Commented:
Vitor: I have a Enterprise 2012. Can i use AlwaysOn ? How it  improve the  performance ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Don't mix performance with availability. AlwaysOn is intended to be an high availability solution. It works like a mirror but with more features since the regular mirror in previous versions of SQL Server doesn't let you access the secondary database. With AlwaysOn you have read access to the secondary database (aka replica database) and you can use it for reporting for example. You'll have everything happening in the primary database and being replicated to the secondary database so you can configure reports to connecting to secondary database so won't affect the performance of the primary database.
But (there is always a but) there are costs associated to AlwaysOn feature and that is the need for one more SQL Server instance (licensing) and more storage for the replica database.
0
ZberteocCommented:
To setup Always On you need 2 separate instances with 2 separate storage units. It is not the same with classic cluster. The performance improvement will come from the fact that you will do your report requests on the secondary node, while the primary will be used exclusively for the application. This way any eventual load due to reporting will not affect your app.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.