Are the threads configured the same for both environments? Each thread has a persistent session with the database; this causes some level of overhead on the db side. The overhead varies depending on the type of db you are using. I can't really speak too knowledgeably about SQL Server, but with Oracle, each session has it's own sql_text area, which equates to an almost direct correlation between the number of active sessions and memory utilization. You still haven't stated what the numbers are a measurement of.
Axton Grams On Jan 26, 2008 7:54 PM, Rob Cvetkovski <[EMAIL PROTECTED]> wrote: > 2 environments - 1 dev 1 prod. > Same database. One copied to the other...same data in both. > Dev SQL service running at 600K...prod at 1.5K > The service is almost double? Is that not strange for the same data & > setup? > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Axton > Sent: Saturday, January 26, 2008 7:21 PM > To: [email protected] > Subject: Re: SQL Service Running at 1.5KB > > 1.5KB is low, no? What exactly are you referring to? > > Axton Grams > > On Jan 26, 2008 6:45 PM, Rob Cvetkovski <[EMAIL PROTECTED]> > wrote: > > ** > > > > Has anyone seen the SQL Service run abnormally high? > > Its SQL Server 2005 with ITSM 7.01 > > Its patched to the latest SP2. > > > > > > > > > > Rob Cvetkovski, Associate Consultant > > > > Burntsand Inc. > > 185 The West Mall Suite 600 Toronto ON M9C 5L5 > > Tel: (416) 234-3839 Cell: (416) 917-7231 www.burntsand.com > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > Are" > > html___ > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
