Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

!!! Database server slowing down Expand / Collapse
Author
Message
Posted Monday, November 19, 2012 12:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 4, 2013 10:19 PM
Points: 330, Visits: 62
I have a vb.net application using SQL database,
I have installed SQL Server 2008 on Server but server does not perform fast and getting timeout message.
Give me a solution.
Post #1386177
Posted Monday, November 19, 2012 12:39 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 4,158, Visits: 5,556
This is not much to go on.
What investigations have you done?
> Have you checked the network?
> Have you checked load on the server?
> Have you tried isolating what exactly is slow?
> Have you checked the indexes / statistics on your database(s)?

We are all volunteers on this site. Without at least some semblance of investigation performed by yourself, it becomes very difficult for us to help you.

therefore:
Please help us, help you -before posting a question please read here
Before posting a performance problem please read here


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1386187
Posted Monday, November 19, 2012 12:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 4, 2013 10:19 PM
Points: 330, Visits: 62
all things are proper
this application run properly on other normal PC
Post #1386188
Posted Monday, November 19, 2012 12:53 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 21, 2014 8:48 AM
Points: 323, Visits: 986
Tanaji Chougale (11/19/2012)
all things are proper
this application run properly on other normal PC




what you mean by all ?

what is
1)Physical memory
2)sql/winodows server configuration
3)which query getting performance issue
4)what is the output off ping IP




-----------------------------------------------------------------------------
संकेत कोकणे
Post #1386190
Posted Monday, November 19, 2012 1:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 2:16 AM
Points: 2,840, Visits: 3,983
Tanaji Chougale (11/19/2012)
all things are proper
this application run properly on other normal PC
it indicates there might be nothing to do with Sql server as if sql server behaves abnormally (slowness) it more or less affect the all the system wih are using that application (or related sql server).


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1386203
Posted Monday, November 19, 2012 2:10 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1386223
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse