Author |
Topic |
petek
Posting Yak Master
192 Posts |
Posted - 2010-01-26 : 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 RegardsPete. |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-26 : 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 pleaseJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2010-01-27 : 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 RegardsPete. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-27 : 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
192 Posts |
Posted - 2010-01-27 : 07:37:51
|
Hi Jackv1). no rouge processes2). no jobs other than db backup3). 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 RegardsPete. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-27 : 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
192 Posts |
Posted - 2010-01-27 : 09:24:00
|
its the same for all the instances:NAME Min MAX Config_Value run_valuemax server memory (MB) 16 2147483647 2147483647 2147483647Kind RegardsPete. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2010-01-27 : 17:04:18
|
How are you connecting to each instance? TCP IP with different ports? |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2010-01-28 : 03:01:44
|
all by TCP IP,Dynamic PortsKind RegardsPete. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2010-01-29 : 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
192 Posts |
Posted - 2010-02-03 : 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 RegardsPete. |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2010-02-04 : 08:52:24
|
in addition use perfmon from sysutilities to monitor sql performance at and instance levelKind RegardsPete. |
|
|
|