<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
interesting approach. SQL server has reporting and diagnostic abilities
to report all of this.<br>
<br>
a few pointers that may help:<br>
<br>
sql profiler - basically a packet sniffer for sql. sql profiler can
track transactions, execution time, cpu cycles, and other useful
diagnostic information.<br>
<br>
sql query analyzer - offers an option to show 'execution plan'. SQL
statements ideally use indexes to perform selects, updates, etc. If
you don't use an index you end up performing a 'table scan'. A 'table
scan' loads every row one at a time to compare criteria. This is very
suboptimal. Use of an index is heavily dependent on your the clauses in
your SQL statements. Even a reordering of the clauses can can
significant performance impact. take the queries that you execute from
UCCX (capture using profiler above) and run them through sql query
analyzer with the option to show execution plan. If you're accessing a
large table and not using an index then you will need to reorder your
statement or create new index.<br>
<br>
a few very handy SQL commands -<br>
'sp_who2' - show active connections to SQL server, spid, active
transactions, and transaction execution time. This is the easiest way
to identify a resource hog from the server side. <br>
<br>
Keep in mind that UCCX potential to "keep some sort of constant open"
is heavily dependent on the script that you authored to perform the
database access.<br>
<br>
'sp_lock' - show active locks in the database. With multiple
applications accessing the same database you increase the potential for
concurrent locks and the ever feared deadlock scenario. If you are
making SQL statements that cause grabbing and holding locks then you
are going to get into serious contention with other applications
attempting to access the same information.<br>
<br>
HTH.<br>
/Wes<br>
<br>
On Wednesday, December 02, 2009 8:16:26 AM, Matthew Loraditch
<a class="moz-txt-link-rfc2396E" href="mailto:MLoraditch@heliontechnologies.com"><MLoraditch@heliontechnologies.com></a> wrote:<br>
<blockquote
cite="mid:530C67FE62559C42857C78B962454E6203BDC259BD@hermes.helion.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">I have one script that does a pretty simple sql
query if a customer enters a ticket number to find the assigned tech,
yet somehow my SQL Admin is reporting the account I have doing that is
chewing up the CPU on the SQL server. We have other Apps that pull from
the same DB every 5 seconds yet they aren’t causing the same Issue.
Does the DB Subsystem in UCCX keep some sort of constant open on a SQL
db?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif";"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color: black;">Matthew Loraditch</span></b><span
style="color: black;"><br>
1965 Greenspring Drive<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Timonium, MD 21093 <br>
<a moz-do-not-send="true" href="mailto:support@heliontechnologies.com"><span
style="color: black;">support@heliontechnologies.com</span></a><br>
(p) (410) 252-8830<br>
(F) (443) 541-1593<br>
<br>
Visit us at <a moz-do-not-send="true"
href="http://www.heliontechnologies.com"><span style="color: black;">www.heliontechnologies.com</span></a>
<br>
Support Issue? Email <a moz-do-not-send="true"
href="mailto:support@heliontechnologies.com"><span
style="color: black;">support@heliontechnologies.com</span></a> for
fast assistance!</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<br>
</body>
</html>