How to improve SQL server performance?

[AHeyne]

@KitaYama : Does your performance problem still exist?

Did you check the "SQL Server Configuration Manager" on your client (which acts as a SQL Server now)?
Take a look into "SQL Server Network Configuration", choose your SQL Server Instance and activate TCP/IP.

Then restart your SQL Server Instance Service and try again.

 

[AHeyne]

@KitaYama : I expect your performance issue was solved before? Would be interested to know the reason.

 

[KitaYama]

@AHeyne The thread is more than a year old. At the time nothing could improve the performance.
We talked to IT guys and they refused to help on configuration on a client. Instead they added a sql server instance on our main server for our tests.
That solved the problem.

Just for the sake of test, I will install it again on my PC this weekend to see if anything's different.

Thanks.

 

[AHeyne]

Thanks for your feedback. I unfortunately overlooked the fact that the thread is so old.