| Author |
 Topic  |
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
 Posted - 01/26/2010 : 11:12:27
|
Hi,
Firstly thank you for looking at this post.
I have 3 named instances installed one box.
The instances respond ok with the exception of one.
Not sure why one of the instances responds so slowly.
please help.
Kind Regards
Pete. |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1775 Posts |
Posted - 01/26/2010 : 16:30:24
|
When you say it "responds slowly" - what do you mean? Is it a specifi query - or something else you are trying to do?
If you could post some extra detail please
Jack Vamvas
--------------------
http://www.ITjobfeed.com |
 |
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 01/27/2010 : 02:13:11
|
Hi thankyou for the response, generally everything from manamgement studio to executing a query to opening diaglog boxes everything seems slower.....
Kind Regards
Pete. |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1775 Posts |
Posted - 01/27/2010 : 07:30:07
|
1)Have you checked that there aren't any processes on your server using excessive CPU , or other resources?
2)Are there any jobs , or background activities on the errant instance?
3)Have you allocated sufficient resources for the third instance?Check in the memory options?
Jack Vamvas
--------------------
http://www.ITjobfeed.com |
|
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 01/27/2010 : 07:37:51
|
Hi Jackv
1). no rouge processes
2). no jobs other than db backup
3). plenty resources......
still not sure why its ruuning slower than the others.
the only diff i found was collation was different on this instance? whould that be anything?
Kind Regards
Pete. |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1775 Posts |
Posted - 01/27/2010 : 08:11:14
|
Have you checked in Activity Monitor for that particular instance ? are there any open transactions?
Could you post the Min server memory and max server memory of that instance , and is that similar to the other instances?Also could you let me know the physical memory of the server.
The tests that you are running across the 3 instances , are they the same?. If not , could your try running similar tests across the 3 instances .
Which sql server edition are you running?
Jack Vamvas
--------------------
http://www.ITjobfeed.com |
|
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 01/27/2010 : 09:24:00
|
its the same for all the instances:
NAME Min MAX Config_Value run_value
max server memory (MB) 16 2147483647 2147483647 2147483647
Kind Regards
Pete. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 01/27/2010 : 17:04:18
|
How are you connecting to each instance? TCP IP with different ports?
|
|
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 01/28/2010 : 03:01:44
|
all by TCP IP,Dynamic Ports
Kind Regards
Pete. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 01/29/2010 : 15:04:19
|
I would suggest giving each instance a specific port, try connecting to it via IP:PORT 192.168.0.2:1434
192.168.0.2:1433
etc
|
|
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 02/03/2010 : 02:30:22
|
hi all thanks for the feedback,
the machine is a vm it had backup jobs running from netapp replicating log files this was using alot of resources, more memory and cpus added (ahh the joy of VMware)........
Kind Regards
Pete. |
|
|
|
petek
Posting Yak Master
United Kingdom
192 Posts |
Posted - 02/04/2010 : 08:52:24
|
in addition use perfmon from sysutilities to monitor sql performance at and instance level
Kind Regards
Pete. |
|
|
| |
Topic |
|
Slow Response from Instance
