SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Slow Response from Instance
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 01/26/2010 :  11:12:27  Show Profile  Reply with Quote
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
2058 Posts

Posted - 01/26/2010 :  16:30:24  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 01/27/2010 :  02:13:11  Show Profile  Reply with Quote
Hi thankyou for the response, generally everything from manamgement studio to executing a query to opening diaglog boxes everything seems slower.....

Kind Regards

Pete.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2058 Posts

Posted - 01/27/2010 :  07:30:07  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 01/27/2010 :  07:37:51  Show Profile  Reply with Quote
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.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2058 Posts

Posted - 01/27/2010 :  08:11:14  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 01/27/2010 :  09:24:00  Show Profile  Reply with Quote
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.
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 01/27/2010 :  17:04:18  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
How are you connecting to each instance? TCP IP with different ports?
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 01/28/2010 :  03:01:44  Show Profile  Reply with Quote
all by TCP IP,Dynamic Ports

Kind Regards

Pete.
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 01/29/2010 :  15:04:19  Show Profile  Click to see tripodal's MSN Messenger address  Reply with Quote
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
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 02/03/2010 :  02:30:22  Show Profile  Reply with Quote
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.
Go to Top of Page

petek
Posting Yak Master

United Kingdom
192 Posts

Posted - 02/04/2010 :  08:52:24  Show Profile  Reply with Quote
in addition use perfmon from sysutilities to monitor sql performance at and instance level


Kind Regards

Pete.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000