We are running an application that uses a SQL database. Users are complaining the application runs slow. For example to just start the application it takes between 40 and 50 seconds.
We have a standalone dedicated SQL 2008 server with plenty of horse power and its not overloaded.
The clients are running on powerful terminal severs as well. Again with plenty of horse power and resources.
during the 40 to 50 second delay both the application server and the SQL server are not busy at all. In fact utilization is extremely low.
As a test I installed the application on an older server using the exact same data only this time the application and the SQL server are running on the same machine. And now bam!! it runs so fast. start up is less the 2 seconds.
Does this mean I have problems or the application itself is the problem when opening a database on a remote server?
I have tested everything I can think of such as disabling antivirus with no luck so far.
Application support says while it would be faster running the SQL locally we should not be seeing such a huge difference but they have no real ideas on how to fix. they mostly talk about resources which I have plenty of.
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …