a:5:{s:8:"template";s:10816:"<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>

<title>{{ keyword }}</title>
<link href="//fonts.googleapis.com/css?family=Open+Sans%7CLato%3A300%2C400%2C400i%2C500%2C600%2C700&amp;ver=5.1.4" id="magbook-google-fonts-css" media="all" rel="stylesheet" type="text/css"/>
 <meta content="width=device-width" name="viewport"/>
</head>
<style rel="stylesheet" type="text/css">body.custom-background div.site{max-width:1320px;margin:0 auto}p.has-drop-cap:not(:focus):first-letter{float:left;font-size:8.4em;line-height:.68;font-weight:100;margin:.05em .1em 0 0;text-transform:uppercase;font-style:normal}p.has-drop-cap:not(:focus):after{content:"";display:table;clear:both;padding-top:14px}html{overflow-y:scroll;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;text-rendering:optimizelegibility}a,body,div,h2,html,li,span,ul{border:0;font-family:inherit;font-size:100%;font-style:inherit;font-weight:inherit;margin:0;outline:0;padding:0;vertical-align:baseline}*,:after,:before{-webkit-box-sizing:border-box;-moz-box-sizing:border-box;box-sizing:border-box}body{background-color:#f4f4f4}footer,header,nav{display:block}ul{list-style:none;margin:0}ul li a{color:#222}ul li a:hover{color:#0c4c8a}@-webkit-viewport{width:device-width}@-moz-viewport{width:device-width}@-ms-viewport{width:device-width}@-o-viewport{width:device-width}@viewport{width:device-width}*,:after,:before{-webkit-box-sizing:border-box;-moz-box-sizing:border-box;-ms-box-sizing:border-box;box-sizing:border-box}::selection{background:#0c4c8a;color:#fff}::-moz-selection{background:#0c4c8a;color:#fff}body,button{color:#484848;font-family:Lato,"Helvetica Neue",helvetica,arial,sans-serif;font-size:15px;font-weight:400;line-height:1.533;word-wrap:break-word;overflow-x:hidden}h2{color:#222;font-family:"Open Sans",sans-serif;font-weight:600;margin-top:0;margin-bottom:15px}h2 a{color:#222;font-weight:inherit}h2{font-size:26px;line-height:1.269}a{color:#0c4c8a;cursor:pointer;text-decoration:none;transition-property:color;transition-duration:.2s;transition-timing-function:linear}a:active,a:focus,a:hover{text-decoration:none}a:focus{outline:thin dotted;outline-offset:-3px}#page{width:100%;background-color:#fff}.wrap:after{clear:both;content:"";display:block}.wrap{margin:0 auto;max-width:1170px;padding:0;position:relative}.clearfix:after{visibility:hidden;display:block;font-size:0;content:" ";clear:both;height:0}.clearfix{display:inline-block}.clearfix{display:block}button{font-size:100%;margin:0;vertical-align:baseline}button:focus{outline:thin dotted;outline-offset:2px}#site-branding{padding:0 10px;text-align:left}#sticky-header #site-branding{display:none}#site-detail{display:inline-block;padding:15px 0;text-align:left;vertical-align:middle}#site-title{font-family:"Open Sans",sans-serif;font-style:italic;font-size:36px;font-style:inherit;font-weight:400;line-height:1.222;margin:0;-webkit-transition:all .3s ease-out 0s;-moz-transition:all .3s ease-out 0s;-o-transition:all .3s ease-out 0s;-ms-transition:all .3s ease-out 0s;transition:all .3s ease-out 0s}#site-title a{color:#222;display:block}.header-wrap{position:relative;display:block;clear:both}.top-bar{background-color:#0c4c8a;margin:0}.top-bar-date{font-size:13px;float:left;padding:8px 15px;color:#fff}.top-header{text-align:center;background-position:center center;background-size:cover}.logo-bar{padding:30px 0}.logo-bar #site-branding{float:left}#sticky-header{border-top:2px solid #0c4c8a;border-bottom:1px solid #ddd;-webkit-box-shadow:0 0 8px rgba(0,0,0,.15);-moz-box-shadow:0 0 8px rgba(0,0,0,.15);box-shadow:0 0 8px rgba(0,0,0,.15);-webkit-transition:all .3s ease-out 0s;-moz-transition:all .3s ease-out 0s;-o-transition:all .3s ease-out 0s;-ms-transition:all .3s ease-out 0s;transition:all .3s ease-out 0s;width:100%;z-index:999}.boxed-layout #sticky-header{width:inherit}.wp-custom-header{position:relative}.header-social-block{float:right}.main-navigation{float:left;margin-right:80px}.main-navigation>ul>li{position:relative;display:inline-block}.main-navigation a{color:#222;display:block;font-family:Lato,sans-serif;font-size:14px;font-weight:700;letter-spacing:.2px;line-height:50px;padding:0 10px;text-align:left;text-transform:uppercase}.main-navigation a:hover,.main-navigation ul li:hover>a,.main-navigation ul li:hover>a:after{color:#0c4c8a}.menu-toggle{display:none}.line-bar,.line-bar:after,.line-bar:before{background-color:#333}#content{padding:40px 0 20px}.boxed-layout #page{max-width:1230px;margin:30px auto;-webkit-box-shadow:0 1px 6px rgba(0,0,0,.15);-moz-box-shadow:0 1px 6px rgba(0,0,0,.15);box-shadow:0 1px 6px rgba(0,0,0,.15)}.boxed-layout #page{overflow:hidden}.site-info{background-color:#222;font-size:14px;line-height:1.571;text-align:center}.site-info .wrap{border-top:1px solid #333}.copyright-wrap{padding:30px 0 10px}.site-info .copyright{color:#666;font-size:12px;float:left;line-height:1.666;text-align:left;margin-bottom:15px}#colophon{font-size:14px;line-height:1.5}.top-logo-title .logo-bar #site-branding{float:none;text-align:center}.top-logo-title #site-detail{display:block;text-align:center}@media print{.site-info,button{display:none!important}body{font-size:12pt}h2{font-size:22pt}.wrap{padding-left:5%!important;padding-right:5%!important;max-width:none}.site-header{background:0 0;padding:0}.site,body{background:0 0!important}a,body{color:#222!important}h2{color:#777!important}.site-footer{padding:0}}@media only screen and (max-width:1300px){.boxed-layout #page{max-width:97%;margin-top:10px}.boxed-layout .wrap,.wrap{max-width:94%}}@media only screen and (max-width:1023px){.boxed-layout #page{overflow:hidden}.header-social-block{display:inline-block;float:none}}@media only screen and (max-width:980px){.boxed-layout #page{margin-top:0}#sticky-header{position:relative!important}#sticky-header{background-color:#fff}.menu-toggle{background-color:rgba(0,0,0,0);border:0 none;color:#666;cursor:pointer;display:inline-block;font-size:0;margin:5px auto 0 90px;padding:20px 0;width:30px}.menu-toggle .line-bar:before{transition:top .1s ease .14s,opacity .1s ease 0s}.line-bar:before{top:-8px}.line-bar:after{bottom:-8px}.line-bar:after,.line-bar:before{content:"";display:block}.line-bar,.line-bar:after,.line-bar:before{border-radius:5px;height:2px;position:absolute;transition-duration:.15s;transition-property:transform,-webkit-transform;transition-timing-function:ease;width:30px}.menu-toggle .line-bar:after{transition:bottom .1s ease .14s,transform .1s cubic-bezier(.55,.055,.675,.19) 0s,-webkit-transform .1s cubic-bezier(.55,.055,.675,.19) 0s}.menu-toggle .line-bar{transition-duration:.1s;transition-timing-function:cubic-bezier(.55,.055,.675,.19)}.line-bar{display:block;margin-top:-2px}.menu{display:none}.top-logo-title .menu-toggle{margin:0;padding:30px 0}.main-navigation{float:none;padding:0}.main-navigation>ul>li{position:inherit;width:100%;border-top:1px solid rgba(0,0,0,.1);margin-left:0}.main-navigation>ul>li::before{visibility:hidden}.main-navigation a{float:none;height:inherit;line-height:1.833;padding:10px 0}}@media only screen and (max-width:767px){h2{margin-bottom:10px}#site-title{font-size:34px}.boxed-layout #site-branding{max-width:400px}.top-bar .top-bar-date{display:none}.header-social-block{float:left}.logo-bar{padding:10px 0}.logo-bar #site-branding{float:none;margin:0 auto;text-align:center}#content{padding-top:50px}}@media only screen and (max-width:480px){.boxed-layout #colophon{margin-bottom:10px}#site-branding{margin:0 auto;max-width:265px}.boxed-layout #site-branding{max-width:240px}}@media only screen and (max-width:319px){.boxed-layout #page,.boxed-layout .wrap,.wrap{width:96%}}@font-face{font-family:Lato;font-style:italic;font-weight:400;src:local('Lato Italic'),local('Lato-Italic'),url(http://fonts.gstatic.com/s/lato/v16/S6u8w4BMUTPHjxsAXC-v.ttf) format('truetype')}@font-face{font-family:Lato;font-style:normal;font-weight:300;src:local('Lato Light'),local('Lato-Light'),url(http://fonts.gstatic.com/s/lato/v16/S6u9w4BMUTPHh7USSwiPHA.ttf) format('truetype')}@font-face{font-family:Lato;font-style:normal;font-weight:400;src:local('Lato Regular'),local('Lato-Regular'),url(http://fonts.gstatic.com/s/lato/v16/S6uyw4BMUTPHjx4wWw.ttf) format('truetype')}@font-face{font-family:Lato;font-style:normal;font-weight:700;src:local('Lato Bold'),local('Lato-Bold'),url(http://fonts.gstatic.com/s/lato/v16/S6u9w4BMUTPHh6UVSwiPHA.ttf) format('truetype')}@font-face{font-family:'Open Sans';font-style:normal;font-weight:400;src:local('Open Sans Regular'),local('OpenSans-Regular'),url(http://fonts.gstatic.com/s/opensans/v17/mem8YaGs126MiZpBA-UFVZ0e.ttf) format('truetype')}</style>
<body class="custom-background wp-custom-logo wp-embed-responsive fully-background boxed-layout two-column-blog n-sld top-logo-title">
<div class="site" id="page">
<header class="site-header" id="masthead" role="banner">
<div class="header-wrap">
<div class="wp-custom-header" id="wp-custom-header"></div> 
<div class="top-header">
<div class="top-bar">
<div class="wrap">
<div class="top-bar-date">
<span>{{ keyword }}</span>
</div>
<div class="header-social-block"></div>
</div> 
</div> 

<div class="logo-bar"> <div class="wrap"> <div id="site-branding"><a class="custom-logo-link" href="#" itemprop="url" rel="home"></a><div id="site-detail"> <h2 id="site-title"> <a href="#" rel="home" title="Fiquimakcc">{{ keyword }}</a>
</h2>
</div></div> </div>
</div>
<div class="clearfix" id="sticky-header">
<div class="wrap">
<div class="main-header clearfix">

<div id="site-branding">
<a class="custom-logo-link" href="#" itemprop="url" rel="home"></a> </div> 
<nav aria-label="Menú principal" class="main-navigation clearfix" id="site-navigation" role="navigation">
<button aria-controls="primary-menu" aria-expanded="false" class="menu-toggle">
<span class="line-bar"></span>
</button>
<ul class="menu nav-menu" id="primary-menu"><li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-44" id="menu-item-44"><a href="#">About</a></li>
<li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-45" id="menu-item-45"><a href="#">Home</a></li>
<li class="menu-item menu-item-type-post_type menu-item-object-page menu-item-70" id="menu-item-70"><a href="#">Contact Us</a></li>
</ul> </nav> 
</div>
</div> 
</div>
</div>
</div>
</header> 
<div class="site-content-contain" id="site-content-contain">
<div class="site-content" id="content">
{{ text }}
<br>
<br>
{{ links }}
</div>
<footer class="site-footer" id="colophon" role="contentinfo">
<div class="site-info">
<div class="wrap">
<div class="copyright-wrap clearfix">
<div class="copyright">2020 {{ keyword }}</div>
</div> 
<div style="clear:both;"></div>
</div> 
</div> 
</footer> 
</div>
</div>
</body>
</html>";s:4:"text";s:3116:"<br>How can I fix the SQL server set up on the server so that I get … sp_who2 is a built-in stored procedure in SQL Server. However, I am struggling to find needed information about sleeping processes that are causing blocking. Listing A: T-SQL job killing open/sleeping transactions (first four lines should be commented out) This process kills transactions that have the following attributes 1.) A Sleeping status means that the Engine has completed the command, everything between client and server has completed interaction wise, and the connection is waiting for the next command to come from the client. Thanks in advance this is not happening on the web server. sp_BlitzFirst® Result: Sleeping Query with Open Transactions According to sp_BlitzFirst®‘s diagnostics, someone started a transaction, got some locks, and hasn’t released them.  In some cases sleeping task is OK it means connection is still there and thread has done its task if you see lot of sleeping task you need to get in touch with application developer to see if sessions are closed after they have done the task – Shanky Jun 30 '15 at 16:20 Fellow SQL Server enthusiast and online friend of mine, Jonathan Kehayias is very active in the MSDN Forums. What options are there to get status information for a database without using the GUI? Use sys.dm_exec_requests instead. I noticed that on SQL profiler when 'Audit logout' executed. My guess is that they were not programmed correctly to be distributed but rather they programmed the app and SQL Server to be on the same server. this is not happening on the web server. 64 BIT SQL Server 2005 on WIN 2003 64BIT ; 12 GB RAM - of which SQL Server is using 11.1 GB at any point of time (as 10GB - SQL and 2GB - CPU)- Still … The reason is ADO.NET has not instructed to remove the connection yet, hence SQL Server still maintains it. If the sleeping session has an open transaction, it is always related to code and not SQL Server. edited Jul 24 '15 at 20:17. I often see this status when all the tasks related to the threads are completed but the connection is still open. Complete the execution and see again. If the status is anything other than “sleeping” (most commonly “running,” “runnable,” or “suspended”), then the values reported are all request-level metrics. A session with that status of sleeping / awaiting command is simply a client connection with no active query to the SQL Server. They're sleeping (i.e. Tab Alleman . The other bit of random info is that if we restart the SQL server, the reports run like lightning. I noticed that on SQL profiler when 'Audit logout' executed. SQL Server Replication https: ... Just try this Opem SSMS run a query it will produce output and you would see its status sleeping which means query is executed and every resource is released so why its sleeping because the SSMS window is open close SSMS window and it will be gone. sp_BlitzFirst® Result: Sleeping Query with Open Transactions According to sp_BlitzFirst®‘s diagnostics, someone started a transaction, got some locks, and hasn’t released them. <br>";s:7:"keyword";s:29:"sleeping status in sql server";s:5:"links";s:867:"<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=chef-on-wheels-living-foodz-episodes">Chef On Wheels Living Foodz Episodes</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=weak-positive-celiac-blood-test">Weak Positive Celiac Blood Test</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=chicken-jalfrezi---shan">Chicken Jalfrezi - Shan</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=loose-furniture-suppliers-in-uae">Loose Furniture Suppliers In Uae</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=zen-garden-statues">Zen Garden Statues</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=it%27s-telling-me-it-might-be-you-lyrics">It's Telling Me It Might Be You Lyrics</a>,
<a href="http://shipashit.com/journal/ti0xi0z.php?e29ecb=kitchen-flooring-home-depot">Kitchen Flooring Home Depot</a>,
";s:7:"expired";i:-1;}