Click here to Skip to main content
15,937,779 members
Please Sign up or sign in to vote.
1.00/5 (4 votes)
See more:
I am using linq to SQL concept.My performance in the local is working fine.When I publish the project and install the application in server it is getting too slow.Can anyone provide the solution for it
dan!sh 18-Jan-16 23:58pm    
Not really. We cannot access your server to tell exactly what is going on. I can provide some pointers though. Enable tracing and profiler to see what is taking time. Check resource utilization on the server to see if you need more hardware. Check the network if travel time is making things slower.
Sergey Alexandrovich Kryukov 19-Jan-16 1:54am    
When you deployed the application, improving its performance is a bit too late. :-)
fakeer muhammed 22-Jan-16 5:28am    
what should i do now?
Sergey Alexandrovich Kryukov 22-Jan-16 10:39am    

1 solution

Observe which page loading/which page operation is slow ? or entire site is slow. There are multiple factors behind site gone slow.
some of them are
1. Slow SQL connection (this is most common reason) try connecting sql with comptername rather than IP address or vice varsa
2. Net work traffic
3. Antrivirus checking
4. RAM capacity
5. Memory assign to SQL
Share this answer
fakeer muhammed 22-Jan-16 5:27am    
how to solve the Memory assign to SQL
koolprasad2003 22-Jan-16 6:29am    
To set a fixed amount of memory

1.In Object Explorer, right-click a server and select Properties.

2.Click the Memory node.

3.Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

Use the default settings to allow SQL Server to change its memory requirements dynamically based on available system resources. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647 megabytes (MB). The minimum amount of memory you can specify for max server memory is 16 MB.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900