Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of monroe@dukece.com designates
 152.3.166.24 as permitted sender)
From: Greg Monroe <monroe@dukece.com>
To: 'Apache Torque Users List' <torque-user@db.apache.org>
CC: "'mjdevlugt@firstcommand.com'" <mjdevlugt@firstcommand.com>
Date: Mon, 2 Feb 2009 16:33:10 -0500
Subject: FW: Torque and SQL 2005 
Thread-Topic: Torque and SQL 2005 
Thread-Index: AcmCVhNcUbFH91U1T2GDz3DWhdxQYAAjcVXQAAciiDAAn0UCAA==
Message-ID: 
 <55B8568AFA5F144F886F18186BAD5B2C054DF2FFE4@durham-e2k7mb1.dukece.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_000_55B8568AFA5F144F886F18186BAD5B2C054DF2FFE4durhame2k7mb1_"

--_000_55B8568AFA5F144F886F18186BAD5B2C054DF2FFE4durhame2k7mb1_
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm forwarding this to the torque-user@db=2Eapache=2Eorg<mailto:torque-user=
@db=2Eapache=2Eorg> mailing list where problem discussion should be held=2E=
=0D=0A=0D=0AFrom: mjdevlugt@firstcommand=2Ecom [mailto:mjdevlugt@firstcomma=
nd=2Ecom]=0D=0ASent: Friday, January 30, 2009 12:48 PM=0D=0ATo: Greg Monroe=
=0D=0ASubject: RE: Torque and SQL 2005=0D=0A=0D=0AI need to find out how to=
 fix the optimistic blocking issues with Torque and SQL2005 - are their any=
 configuration settings that can be fixed whether its SQL 2005 or Torque th=
at we can change those settings for selects to run without escalated blocki=
ng (and the issue with "Implicit On" for selects?=0D=0A=0D=0AI'm a =2ENET/S=
QL DBA so it's hard for me to see how to fix "Implicit On" when the transac=
tion stays open for 30-40 minutes per connection and they say that Torque i=
s where that setting is maintained within code and we are using app pools s=
o we have to restart app/sql daily=2E It looks like it's a SQL2005 issue be=
cause of all the blocking, but I think it's a Torque/code/config/driver iss=
ue and the "it's your fault not mine" is happening instead of "lets get thi=
s working"=2E  Microsoft just states the vendor has to fix their code and u=
se the latest Microsoft JDBC driver - they are using the 1=2E2=2E4 version =
=3D maybe that is the issue too=2E  Using torque, maybe I should use the JT=
DS driver?  Any suggestions would be helpful=2E  The app is setup to scan a=
 lot of records with dynamic SQL so SQL is escalating locks to an exclusive=
 table lock with each process so it limits the number of people that can us=
e the app=2E  I max about 15 people and I need to get it usable for 400!  T=
hey have about 800 tables in their database=2E  The inserts/Updates are so =
quick that most of those transactions don't even show up in the SQL traces,=
 so it's just the Selects that I am having issues with=2E=0D=0A=0D=0AWell, =
Thanks again for responding and sending any information that will help me i=
f you are able to=2E=0D=0A=0D=0AHave a great weekend=2E=0D=0A=0D=0A=0D=0AMa=
ry Myers-DeVlugt, MCDBA2008, MCITP2008, MCTS=0D=0A=0D=0ASQL Database Analys=
t/DBA=0D=0AFirst Command Financial Services, Inc=2E, parent of=0D=0AFirst C=
ommand Financial Planning, Inc=2E=0D=0A1 FirstComm Plaza, Fort Worth, TX 76=
109-4999=0D=0A(817) 569-2043 (office)   (817) 569-2690 (fax)=0D=0A(817)  90=
3-5198 (cell)     (817) 577-4694 (home)=0D=0Amjdevlugt@firstcommand=2Ecom<m=
ailto:mjdevlugt@firstcommand=2Ecom>=0D=0Awww=2Efirstcommand=2Ecom<http://ww=
w=2Efirstcommand=2Ecom>=0D=0A=0D=0A=0D=0A=0D=0A____________________________=
____=0D=0AFrom: Greg Monroe [mailto:monroe@dukece=2Ecom]=0D=0ASent: Friday,=
 January 30, 2009 8:23 AM=0D=0ATo: Myers-DeVlugt, Mary=0D=0ASubject: RE: To=
rque and SQL 2005=0D=0A=0D=0AYes, in fact, we're using 2005 for our main To=
rque based apps now=2E=0D=0A=0D=0AFrom: mjdevlugt@firstcommand=2Ecom [mailt=
o:mjdevlugt@firstcommand=2Ecom]=0D=0ASent: Thursday, January 29, 2009 4:11 =
PM=0D=0ATo: Greg Monroe=0D=0ASubject: Torque and SQL 2005=0D=0A=0D=0AIs Tor=
que supported for SQL2005?=0D=0A=0D=0Ahttp://db=2Eapache=2Eorg/torque/versi=
on-specific/supported-databases=2Ehtml=0D=0A=0D=0AThanks,=0D=0A=0D=0AMary M=
yers-DeVlugt=0D=0Amjdevlugt@firstcommand=2Ecom<mailto:mjdevlugt@firstcomman=
d=2Ecom>=0D=0ASQL Database Analyst/DBA=0D=0AFirstCommand Financial Planning=
=0D=0A817 569 2043 office=0D=0A817 903 5198 cell or 817 577 4694 home=0D=0A=
817-213-9954 or 8172139954@page=2Emetrocall=2Ecom=0D=0A1 FirstComm Plaza, F=
ort Worth, TX 76109=0D=0A"Opportunity knocks at your door every day - answe=
r it"=2E=0D=0A=0D=0A=0D=0A________________________________=0D=0AFirst Comma=
nd Financial Services, Inc=2E, parent of First Command Financial Planning, =
Inc=2E (Member SIPC), a registered broker-dealer and registered investment =
adviser, and First Command Bank=2E=0D=0A=0D=0AFinancial planning services a=
nd investment products, including securities, are offered by First Command =
Financial Planning, Inc=2E Insurance products and services are offered by F=
irst Command Financial Services, Inc=2E In certain states, as required by l=
aw, First Command Financial Services, Inc=2E does business as a separate, d=
omestic corporation, and does business in California as "First Command Insu=
rance Services=2E" Banking products and services are offered by First Comma=
nd Bank=2E Securities products are not FDIC insured, not bank guaranteed an=
d may lose value=2E=0D=0A=0D=0ASTATEMENT OF CONFIDENTIALITY: The informatio=
n contained in this message or any attachments to this message are intended=
 only for the person(s) or entity to which it is addressed and may contain =
confidential and/or privileged material as well as being protected from dis=
closure=2E The information contained herein is based on sources we believe =
reliable but is not considered all-inclusive=2E Any review, retransmission,=
 dissemination or other use of, or taking of any action in reliance upon, t=
his information by persons or entities other than the intended recipient is=
 strictly prohibited=2E If you received this in error, please contact the s=
ender immediately and delete the material from any computer=2E www=2Efirstc=
ommand=2Ecom=0D=0A________________________________=0D=0ADuke CE Privacy Sta=
tement=0D=0APlease be advised that this e-mail and any files transmitted wi=
th it are confidential communication or may otherwise be privileged or conf=
idential and are intended solely for the individual or entity to whom they =
are addressed=2E  If you are not the intended recipient you may not rely on=
 the contents of this email or any attachments, and we ask that you please =
not read, copy or retransmit this communication, but reply to the sender an=
d destroy the email, its contents, and all copies thereof immediately=2E  A=
ny unauthorized dissemination, distribution or copying of this communicatio=
n is strictly prohibited=2E=0D=0A=0D=0A=0D=0A=0D=0ADukeCE Privacy Statement=
:=0D=0APlease be advised that this e-mail and any files transmitted with=0A=
it are confidential communication or may otherwise be privileged or=0Aconfi=
dential and are intended solely for the individual or entity=0Ato whom they=
 are addressed=2E If you are not the intended recipient=0Ayou may not rely =
on the contents of this email or any attachments,=0Aand we ask that you ple=
ase not read, copy or retransmit this=0Acommunication, but reply to the sen=
der and destroy the email, its=0Acontents, and all copies thereof immediate=
ly=2E Any unauthorized=0Adissemination, distribution or copying of this com=
munication is=0Astrictly prohibited=2E
--_000_55B8568AFA5F144F886F18186BAD5B2C054DF2FFE4durhame2k7mb1_--