Slow DB Connection using MS SQL 2005 (1 Viewer)

[azimek]

Problem using mS SQL Server Express with MP TV Server and MP Client - multiseat.

In Configuration and in TV Client the system waits about 40 seconds when it tries to get the channels from SQL db:
LOG:

2009-01-07 18:48:01.985220 [Info.][Config Main]: get channels from database
2009-01-07 18:48:44.445660 [Info.][Config Main]: found:62 tv channels

This happens only on TC clients not on the server itself.
It seams that it takes 40 seconds to establish the dbconnection (monitored this using SQL Management studio)
The statement executed is:
(@idGroup int)select idGroup, groupName, sortOrder from ChannelGroup where idGroup = @idGroup;

Firewall and everything is set up OK. I don't get any errors - it's only the TIME PROBLEM - 40 seconds !!

Need help with this.

Server is RC4, clients are mixed RC4 an 1.0 - same problem on every system (except server).

Thanx André


TV-Server Version: RC4
MediaPortal Version: RC4
MediaPortal Skin: BlueTwo3 Wide
Windows Version: Vista 32bit SP1
CPU Type: Intel QuadCore Q 6600
HDD:
Memory: 3GB
Motherboard: ASUS
Video Card: NVIDIA 8800GT 512mB
Video Card Driver: latest
Sound Card: on board SB Audigy
Sound Card AC3: SB AC3 SPDIF to DENON Receiver
Sound Card Driver: latest
1. TV Card: FireDTV DVB-S2 mit Premiere
1. TV Card Type: DVB-S
1. TV Card Driver: latest
2. TV Card: FireDTV DVB-S2
2. TV Card Type: DVB-S
2. TV Card Driver: latest
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: MainConcept / DScaler
MPEG2 Audio Codec: MainConcept
h.264 Video Codec: MainConcept CoreAVC Pro
Satelite/CableTV Provider: Astra Germany
HTPC Case: DELL XPS 420
Cooling:
Power Supply:
Remote: MCE IR and MS Keyboard IR
TV: Panasonic PZ700E 50'' FullHD
TV - HTPC Connection: HDMI

STRANGE !

I disabled TCPIP V6 on both vista systems (client and server) and now the connection time is only 25 seconds ?!?!?

Any suggestions

 

[azimek]

Fixed slow network client server connection

So the connection to the SQL server had nothing to do with the problem *sorry for that*

BUT !

My solution is for everybody using a multi seat setup.
Using wireshark I found the problem, why a client needs up to 20 seconds to connect to a mp server.
All databases, thumbs, coverart and fanart for moving pictures are shared on the network.

MP Setup configures the Windows firewall but I had to exclude one more tcp port so everything is working fine.

Exclude / open port : 49177 TCP

Problem solved !

André

 

[Swede]

Hmm, are you shure? Only way I can get my clients to view shares within reasonable time is to shut down MP in my server and restart the client MP. Somehow the access to the database is delayed with about 20 sec if server MP is running and has opened a shares folder.

I tried to open 49177, but no difference for me I haven't rebooted yet. Maybe I need to do that.

https://forum.team-mediaportal.com/general-support-51/re-slow-browsing-shares-47953/

 

[snorre]

I had the exact same problem as azimek, my clients halted for 3 minutes during startup. I tried to open to port azimek suggested but it didn't solve my problem. So instead I added sqlservr.exe as an exception in the Windows firewall and now everything is fine! Fast startups on all clients.

 

[tklon]

So instead I added sqlservr.exe as an exception in the Windows firewall and now everything is fine! Fast startups on all clients.

This fixed my multiseat setup.