SQLServerCentral / SQL Server 2005 / SQL Server 2005 Performance Tuning

Memory usage not matching up with that shown in DMV's

winston Smith — Mon, 15 Apr 2013 03:23:30 GMT

I have a sql 2005 64bit instance on a 64bit windows server.The Server has 32Gb RAM Total with 26GB set as MaxServerMemory for SQL Server.Lock Pages in Memory is enabled for SQL Server.We are getting a lot of very Low Page Life Expectancy alerts on this server.External memory pressure is not the problem so it has to be internal to sql server.On checking the sys.dm_os_memory_clerks to help identify high consumers in single and multi page allocators, we can only see that about 4Gb is used by single page allocations and 3GB is used by multi page allocations.We cannot see where the rest of the memory is being used. Im not sure what next steps to take to identify the heavy consumer of RAM, so any suggestions would be appreciated.Thanks!

One interviewer asked me this following question

bmr270 — Mon, 25 Oct 2010 15:07:34 GMT

Hi,One interviewer asked me this following question.A 200 lines stored procedure working fine till yesterday, but today morning it is taking long to run. How can you find where the problem is and what is the cause for this?I said the there may be network problem. He did not agree. Can you help?

CPUs and SQL Server

Andrew Pruski — Wed, 08 May 2013 06:51:45 GMT

Hello,I have a server running an instance of SQL Server 2005 and SQL Server 2012 (both standard editions).The server has 2 CPUs with 12 cores. My question is that as SQL Server Standard Edition can only utilize 16 cores, is it worth me limiting the instances to only use a specific set of cores, or would it be better to leave alone?I am running PerfMon to see the utilization of each core but would like people opinions (please).Any advice would be most appreciated.Andrew

How to balance query optimization and data manipulation performance

Keion Francis — Fri, 26 Apr 2013 12:53:21 GMT

I have a report/issue management application that has an interactive dashboard that allow users to drill from bar, line and area charts to a summary page(data grid). The summary page aggregates the totals for reports represented by the charts. Users are then able to open reports to view the records/issues that are present.The records for the report is displayed in a data grid. Users are then able to change the properties of the records which will intern affect the dashboard charts. For example, a user can open a report and change the state of one of the records from 'open' to 'close'. This is an enterprise application that is used by multiple users at the same time, so changes made to reports will affect multiple users. I have one central table that manages all the properties of the records/issues for all the reports in the system. I use this table to create a view with other supporting tables to generate the data for the charts and summary pages for the dashboard. I created few(5) covering indexes to improve performance for some of the queries. However, as the data grows in the table, the performance deteriorates. Also, the performance of updates suffer significantly as data grows as well. I would like to know what can I do to improve the performance of this application given the fact that I am using the same data to generate charts and the data is also changing? Is there a better design that I can explore?Any help I can get with this problem will be greatly appreciated.

Locks on tempdb objects

Eugene Davydov — Tue, 23 Apr 2013 12:59:53 GMT

Hi all.I'm calling for your help please. I've a problem in production:there's a transaction which is opened from the business logic (TransactionScope) and in some cases perfoms a lot of actions such as insert/update/delete by one row in some quantity (about 10) of tables in the [b]DB1[/b].There's a block of methods which perfomes selects on [b]DB2 [/b](which tables aren't blocked by this transaction) in a middle of transaction before block of another few DML methods (so we can't complete tran).So the problem is that these selects perfom very slowly (0.5 sec), meanwile the same without the scope of transaction and with the same plan perfoms very fast (30ms).I think the key is in the large quantity of key locks (about 1.5million in sys.dm_tran_locks for specific session). Escalation can't be thrown because of key operations (but not about 5000 at time). So I'm trying to solve this situation by blocking a whole table before DML operation for that case so reducing amount of key-locks.But the problem is that I can't (at this moment) eliminate a lot of key, page, object locks [b]on tempdb[/b]. But according to the situation above I suggest that reducing locks in [b]DB1 [/b]and the existence them in [b]tempdb [/b]won't solve the problem. [u]And how do you think?[/u] What should I do? Only to find the procedures with temp tables and change them to variables?Thanks.

Database Data File Physical Fragmentation From Small Auto-Growth Setting

Gail Wanabee — Thu, 17 Jan 2013 07:40:03 GMT

I've placed this post in the SS2005 Performance Tuning section of the forum because it was totally ignored in the 2012 section of the forum.The server is SS2012.________________To All,I need some advice. I've just started a new job and one of the first problems I've encountered is that a 365 GB database has auto-grown 1 MB at a time since the day it was created.3 years ago, the database was on direct attached storage. Then, it was moved to a Dell-Compellent SAN, a system for which I am a certified administrator. The database migration involved a database backup and a restore to the SAN which eliminated the physical fragmentation. But after that, it kept auto-growing in 1 MB increments. So, it probably has at least 100,000->200,000+ 1MB file fragments scattered all over multiple disk drives.I am going to review the performance implications of this condition with Dell-Compellent.In the meantime, I'd like to hear from any of the community on this forum:1. If you've had this situation, how did you respond to it?2. Is the potential for server performance degradation reduced if the database data file is on a SAN?3. If I must take action to rectify this condition, what are my best options?On the last question, I'm considering 3 options:1. A full backup and restoration of the database:1a. Backup the database.1b. Take the database out of production.1c. Delete the database.1d. Recreate the database with appropriate initial and auto-growth settings.1e. Restore the database.1f. Reconnect the Login and User SIDs.1g. Resume production.2. Take a SAN based snapshot of the database and use it to replace the existing database. (I don't think this will produce the desired results and I'm going to review it with Dell-Compellent.)3. File defragmenting software. There is a file defragmenting program available from Microsoft that is specifically designed to turn physically fragmented files into contiguous files: http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx. Contig.exe Version 1.7. It sounds promising.I would be very interested in your responses, especially if you've actually had to solve a similar problem.

Creating new database with existing MDF(only MDF) file.

Joy Smith San — Wed, 22 Oct 2008 23:37:12 GMT

Dear All,I have downloaded MDF of my database from live server to local server.Now I want to create a database in loocal server pointing to this MDF file.How can I do it..?Thanks in advance.Santhu.

CXPACKET

lianvh 89542 — Fri, 19 Apr 2013 01:50:06 GMT

Good Day,our environment runs on SQL Server 2008R2 64 bit Ent with 32 CPUs and 200 gig of memory . When I run diagnostics queries to see which processor is busy , there are only 4 processors at a time with readings lower than 10 at a time the others have readings of 0 . We did add the required indexes and tuned the code , but we still get CXPacket SOS_SCHEDULE_Yield waits . Any ideas ?

CXPACKET wait type

flyme4ual — Tue, 14 Oct 2008 23:34:18 GMT

Hi guys,I'm seeing CXPACKET wait types in one of my database running SQL2005 which causing the CPU hit 100%. The server is 64 bit Windows 2003 with 8 CPU. Several tables contain over 10 million rows. Does anyone encounter this issue before and what was done to fix the problem?Thanx.

Performance Monitoring Software

Andrew Pruski — Thu, 18 Apr 2013 11:17:49 GMT

Hello,Not sure if this is the right section but I am currently testing three software products that will allow me to analyze the performance of the database servers I administer.The products are:-Confio - IgniteRedGate - SQL MonitorIdera - Diagnostic ManagerI'm just wondering what experiences people have had with these products. I've seen adverts for SQL Monitor everywhere but have limited experience with it. I've used Idera in the past but it is expensive (last quote of $2,000 per instance).Ignite seems to be a bit different from the others, focusing on SQL queries executed more.Any advice would be most appreciated.Andrew

so many indexes indexes

Zeal-DBA — Mon, 15 Apr 2013 19:11:04 GMT

what if i create so many indexes in a database, on each and every table small or large...? any bad impact possible in performance or maintenance point of view....?

Join's and Index's

dwilliscp — Wed, 30 Jan 2013 12:22:54 GMT

I am fuzzy on this.. so looking to see if my thoughts are correct... When looking at the execution plan, it does not ask for an index, but...If you have two moderate (500K to 1M) tables, and both are a heap, wouldn't it help the inner join to have index's on what is being joined? If it matters, one is a temp table (#temp) so it would already exist in memory.. one would hope.

Max server memory setting

Zeal-DBA — Thu, 11 Apr 2013 11:56:01 GMT

In one of the server we have defined 'max server memory' below is the server configurationOS = windows server 2003 enterprise edition 32 bitSQL = sql server 2005 standard edition 32 bittotal RAM = 64 GBMax server memory = 48 GBAWE = enabledplease let me know how can check if max server memory should increase for 2 or 4 GB more?please reply

Missing index details

Zeal-DBA — Thu, 11 Apr 2013 12:01:45 GMT

SELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure,mid.statement as fullyqualifiednames, 'CREATE INDEX [missing_index_' + CONVERT (varchar, mig.index_group_handle) + '_' + CONVERT (varchar, mid.index_handle) + '_' + LEFT (PARSENAME(mid.statement, 1), 32) + ']' + ' ON ' + mid.statement + ' (' + ISNULL (mid.equality_columns,'') + CASE WHEN mid.equality_columns IS NOT NULL AND mid.inequality_columns IS NOT NULL THEN ',' ELSE '' END + ISNULL (mid.inequality_columns, '') + ')' + ISNULL (' INCLUDE (' + mid.included_columns + ')', '') AS create_index_statement, migs.*, mid.database_id, mid.[object_id]FROM sys.dm_db_missing_index_groups migINNER JOIN sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handleINNER JOIN sys.dm_db_missing_index_details mid ON mig.index_handle = mid.index_handleORDER BY migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks + migs.user_scans) DESCthis query gives me around 490 indexes, i think i cant create blindly all the indexes, please advice some parameter on what basis i can choose most required indexes only.and there must be some indexes already created, i dont want to create duplicate one. any idea how can filter already created indexes in this script.

Do views use an optimised execution plan?

invisibleduncan — Tue, 02 Apr 2013 07:58:41 GMT

Do views use an optimised execution plan? I always thought they didn't, and that this was one of the arguments for using them sparingly. However, a colleague has mentioned that he thinks they do use an optimised execution plan, although he thinks they get optimised the first time you run the view, and that you need to have Auto Update Statistics set to ON for the database.I've tried searching for an answer, but unfortunately if you include "View" in a search about execution plans, all you get are ways of viewing execution plans.Any knowledge gratefully received. :-)

Reorganze index and Statistics

EL_oh_EL — Tue, 26 Mar 2013 22:39:22 GMT

Looking for some clearer answers here...we have quite large databases 1TB+ and we are doing nightly Reorganize of our index. There is no job for statistics update. When should statistics update job should be scheduled for ? before or after the Reorganize of indexes? auto create and update statistics option are enabled for the database.

Indexes with Include

Ray Laubert — Fri, 26 Jun 2009 08:07:55 GMT

I am performance tuning a database for a client. I have used several methods to identify tables that could use some indexes, but also want to keep the indexing workload to a minimum.SQL and Profiler's recommendations include several new indexes on some of the tables that recommend include columns. My question is does SQL look at the order of the include columns when making an index selection.Here is an example:Index 1 recommendationIndex Key: [SCHOOL_YEAR] Include Key: [COURSE_KEY], [STUDENT_KEY], [DISTRICT_KEY], [LOCATION_KEY]Index 2 RecommendationIndex key: [SCHOOL_YEAR] Include Key: [COURSE_KEY], [STUDENT_KEY], [PERIOD_KEY], [SECTION_CODE], [REQST_SEQUENCE], [ENROLL_KEY], [EFFECTIVE_DATE], [DISTRICT_KEY], [LOCATION_KEY], [DELIVERY_MODEL_KEY]Index 3 RecommendationIndex Key: [SCHOOL_YEAR] Include Key: [COURSE_KEY], [STUDENT_KEY], [PERIOD_KEY], [SECTION_CODE], [REQST_SEQUENCE], [ENROLL_KEY], [EFFECTIVE_DATE], [DISTRICT_KEY], [LOCATION_KEY]Index 4 RecommendationIndex Key: [SCHOOL_YEAR] Include Key: [COURSE_KEY], [STUDENT_KEY], [SECTION_CODE], [DISTRICT_KEY], [LOCATION_KEY]Index 5 RecommendationIndex Key: [SCHOOL_YEAR] Include Key: [COURSE_KEY], [STUDENT_KEY], [SECTION_CODE], [REQST_SEQUENCE], [ENROLL_KEY], [EFFECTIVE_DATE], [DISTRICT_KEY], [LOCATION_KEY], [DELIVERY_MODEL_KEY]Index 6 RecommendationIndex Key: [SCHOOL_YEAR] Include Key: [DISTRICT_KEY], [LOCATION_KEY]All of these values are either DATETIME or BIGINT.Goal is to keep the number of indexes to a minimum while providing the most benefit for reports and queries.My thoughts are recommendations 2 & 5. But if the order or number of non used included columns is a factor in the index selection, then I would have to re-evaluate based on percentage of use/improvement and Index recommendation 6 would be the only one created.I could not find the selection criteria on how SQL chooses an index with include columns other than it would use one the had ALL of the columns required to fulfill a query.Unfortunately, I do not have the access nor the time left on the contract to test each of these scenarios out.Thanks for your inputs

SQL Server 2005 - Connection timeouts at specific times

gwgeller — Wed, 27 Mar 2013 11:15:43 GMT

We are running SS2005 behind our website. We are still using classic ASP. We are experiencing timeouts when trying to open a connection using ado. This started happening around Nov/Dec of 2012. There is no pattern on what days it happens. However the times are always 8:55a, 5:05p and 8:05p. Note these are the time when it happens, but one day it may be 8:55a and the next day 5:05p. Then maybe the next day it happens at all three times. We have a lot going on at the top of the hour, but it's every hour not just these times. Also I do not see any jobs that run only at theses time. It's so frustrating because the times are so specific.What is odd is we've seen timeouts on queries being run from ASP, but I've never seen consistent timeouts when trying to open a connection from ASP until this started happening. To me that is an important factor. To me it seems a network issue. I want to note too that I'm not seeing any issues with the jobs, only the connections from ASP to our db server. However this could be because our jobs run on a different NIC than our IIS server, for the most part. This again leads me to a network issue.I have performance monitoring setup some common network, system and sql server counters, but I do not see anything obvious. However I'm not an expert so I may have missed something.I've also recorded the output of sp_who2 every 10 seconds during these periods. I haven't found the issue, but I do see the connections pile up after the issue has happened. Probably a jump from 40-50 to 80-90 open connections. So something is bogging down or backing up, but I don't see anything even running. Everything is "awaiting command" except for my sp_who2 call. Also there is no blocking going on. Even the lead up to the bog down I'm not seeing any process running a command in sp_who2. Basically what I'm seeing is around 40-50 processes "awaiting command" every 10 seconds and then all of the sudden I'm up to 80-90 processes "awaiting command". One interesting thing I saw yesterday was that there was a 30 second gap, instead of 10, between two sp_who2 calls. So whatever was happening delayed the call. This isn't consistent though.Based on the performance monitoring and sp_who2 data I don't see anything obvious with sql server. I'm leaning towards something bogging down the network. I might try to pull out the network counters from my performance monitoring and make a separate one so it's easier to view.Can anyone add some input or point in the right direction as far as what I should be monitoring and what I should be looking for?

Updating covering Index

nadersam — Wed, 27 Mar 2013 07:18:25 GMT

Dear All,I have a covering index Idx1 on Col1 included Col2 and Col3.My question is if i run the following statementupdate tbl1 set col2=anyvaluewill that update statement trigger an update on Idx1 or not?.I am asking that because i have a big table with a column included in many indexes and i am afraid that could have an impact on performance when executing update statements on that included column.Thanks in advance.Nader

sql pages out before hitting low memory

foscsamuels — Mon, 18 Mar 2013 09:55:43 GMT

What can I do to prevent SQL from paging out its memory?Situation:I receive calls about SQL App being slow.event viewer shows A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 57040, committed (KB): 1608152, memory utilization: 3%%Memory monitor shows just over 4 gb still free.graph shows memory available.[img]http://i46.tinypic.com/sbsrhw.png[/img]

sql server 2005 (std edition 32 bits) on windows server 2003 enterprise 32 bits

chewychewy — Tue, 12 Mar 2013 03:05:52 GMT

Hi Guys,I have 8GB RAM on windows server 2003 enterprise 32 bits. From my computer, right click properties I can see 8GB.However, i notice that my db instance can only use up to 1.6GB. (I didn't set max memory setting).In order for my sql server 2005 (std edition 32 bits) instance to use more than 1.6GB memory, I understand that I will need to enable lock pages memory for the db service account and enable AWE in sql server.However, do i need to add /PAE to my below boot.ini as well? What is the diff between /PAE and /3GB?thanks![boot loader]timeout=30default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /noexecute=optout

Can Someone Explain These Wait Times to Me?

tfendt — Mon, 11 Mar 2013 10:09:20 GMT

So I know what wait times are, the amount of time SQL spends waiting on a resource. What I don't understand is how this equates to end user wait time and how the numbers can be so high.Take for example my companies total disk wait stats for 2012: 249,440,577,575ms or 7.9 years! I know there are multiple processes that can wait at the same time but 7.9 years of waiting seems crazy. My average disk read latency for last year was 3.6ms and write latency was 3.8ms so I don't think I have a disk issue.Here is another example: in the past day my total disk resource waits are 11,252,662ms or 3.1 hours. Nothing seems to be hanging up and I am not getting any reports of the system being slow. The total CLR waits for the same time period are 30,302,950,440ms. I know Microsoft says you can safely ignore CLR waits but a number that large I have a hard time ignoring.Could it be that I am just looking at waits that are okay to ignore and my actual wait time is not that high? Hopefully someone here can help, I'm lost at trying to explain it.[img]https://dl.dropbox.com/u/404897/SQL%20Waits.JPG[/img]

Re-Index :Performance ISSUE

vishalsurya50 — Fri, 15 Mar 2013 05:31:01 GMT

Hi, In Our environment we have a job in sql server 2012 which has two steps .1)Executing a stored procedure.2)Re-Index for all tables in a database where large no of tables are present. It occurs daily. Normally the jobs takes only 5 mins to execute successfully. But yesterday the job executed for more than 7 hrs which affected production users and i stopped it manually. Dont know why?Whether it may be due to deadlock?. How to prevent it from deadlock if present in future. Can you let me know the reason and to avoid it in future. RegardsVishalsurya

High Index Count/Space versus High CPU and Logical/Physical Reads

DB_Newbie2007 — Wed, 06 Mar 2013 13:59:52 GMT

We are working on trying to reduce the high number of IO waits on one of our production servers, a large percentage of which appears to come from one of our applications (based on the queries that have the highest accumulated physical reads, other investigations we have done). The application writes a large amount of data into a holding table (kind of like a temp table), then runs various queries to normalize (distribute the data into smaller tables with specific data, say one table for sales info, one table for invoices/sales info, one for employee info, one table for customer info, addresses, etc.) and partitions the data (into a month/year partition, i.e., Invoices_Oct12, Invoices_Nov12, etc.). I realize this is one of those "it depends" kind of questions, but I need to get a sanity check before I commit these changes: One of the stored procedures (the one that normalizes the data) runs 18 individual queries as part of the normalization. When reviewing the execution plans, each query produced a "missing index" recommendation. Just for testing, I applied all of the recommendations (they just go on the holding table, not the normalized tables receiving the final data). The overall query time does not change significantly (nature of the inserts?), but the CPU time, scan counts, logical and physical reads definitely go down (in some cases, 94% improvement). However, this comes at the expense of the indexes consuming more space than the data (3:1 ratio). [b]Question:[/b] would it make sense to apply the indexes and live with the higher space consumption (which is kind of temporary and should not really increase over time) versus the CPU and read performance? I am thinking the answer in this case is YES, but I would be interested in other people's opinions. :)The application does bulk inserts, so I do not believe the initial inserts into the holding/temp table would be affected (still to be tested).Thanks! :)

Resolving a deadlock

pamozer — Mon, 04 Mar 2013 18:06:00 GMT

I have a deadlock between a trigger and a stored procedure stored procedure is always the victim of the deadlock. I believe I know what the issue is but I am not sure how to fix it.I have one stored procedure that calls multiple stored procedures. One of the inner stored procedures updates a patient table which has the trigger on it. The trigger updates one of the fields that is being updated by the stored procedure. I think the deadlock is occurring because there is a transaction in the application around the multiple stored procedures so that when the trigger is updating the column the stored procedure is also trying to commit its changes. Does this make sense?Would it make any difference if I were to take the innards of the stored procedure that's being called and put them inline in the stored procedure that's calling it? Would it wait to try to run the trigger until after the update is committed? I can certainly show the stored procedure but its over 2000 lines long. Let me know if you need additional information.thanks

Performance Issues when backing up BI db's

smthembu — Tue, 05 Mar 2013 04:46:50 GMT

Hi AllI migrated the old server to a new server of which it’s a VM. Now the backups taking long but other sql processes have improved 90% in performance but the backups seems degrading. Had a word with infrastructure guys and storage seem not to agree. Performance from the front end tool is great BI is happy but i'm not the happy one with backups performance. Please advice if i missed something.New ServerVM Hosted server storage configuration SANSQL Svr 2005 Ent 32bit SP4 (Upgraded the SP2 to SP4)Windows Ent 2008 R2 64bit SP116GB RAMIntel(R) Xeon(R) CPU E7- 2870 @ 2.40GHzPhysical CPU count 8AWE enabledLIPM sql service account addedMax Server memory 14GBBackups to the local drive with HyperBac took 3hrs 50min to complete -------------------------------------------------------------------------------------Old ServerSQL Svr 2005 Ent 32bit SP2Windows Ent 2003 32bit SP18GB RAMIntel(R) Xeon(R) CPU 5160 @ 3.00GHzPhysical CPU count 4LIPM sql service account addedAWE enabledMax Server memory 6GBBackups to the local drive with HyperBac took 1hr 18min to complete

High work_queue_count and THREADPOOL WAITS

steve.smith 42985 — Thu, 30 Dec 2010 07:40:36 GMT

HiI am tuning the DB activity for an application that sends a high number of transactions in a very short space of time via a large number of threads.When activity is highest I am seeing:"SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems."and related connection errors on the application. Eventually the DB becomes unresponsive and I need to use the DAC to get a connection. Investigating DMVs I find that the highest WAIT stat is THREADPOOL (at 50% of resource WAITS) and SIGNAL WAITS are only < 8% This led me to investigate sys.dm_os_schedulers, as it looked like possibe worker starvation, but I am struggling to understand the results I get:'SELECT max_workers_countFROM sys.dm_os_sys_info' is 256and yet 'SELECT scheduler_id , cpu_id , Status , is_online , is_idle , current_tasks_count , runnable_tasks_count , current_workers_count , active_workers_count , work_queue_count , pending_disk_io_count , load_factorFROM sys.dm_os_schedulersWHERE scheduler_id < 255 AND runnable_tasks_count > 0'Shows only about 120 active workers, but 78 queued (see below)0 255 VISIBLE ONLINE 1 0 97 9 61 61 36 0 1881 255 VISIBLE ONLINE 1 0 100 20 58 55 42 2 189in fact 'select count(0) from sys.dm_os_schedulers' is never more than 130Can anyone explain why the DB seems to become starved of workers when only half of the workers are allocated?Regards, SteveThis environment is a 2 vCPU VM running Windows Server 2003 and SQL 2005 SP3, it is running on a HOST with 4 cores.

DeadLock

Muralidaran — Wed, 29 Apr 2009 01:36:48 GMT

HiI am getting below error:Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transactionI have given trace logs and table,SPs. When client application restarts due to power failure, all these 3 SPs are called from 200 clients.(server is supported with UPS). All the SPs are trying to update,select(,insert) a single table at the same time.Can you please help to sort this problem?CREATE TABLE [dbo].[STB]([STBId] [char](12) NOT NULL,[IpAddress] [varchar](15) NULL,[RestartTime] [datetime] NULL,[RoomNo] [varchar](10) NULL,[ImageVersion] [varchar](10) NULL,[DeployImageVersion] [varchar](10) NULL,[IpUpdated] [datetime] NULL,[TVstate] [smallint] NULL,[CurrentFeatureUsed] [int] NULL,CONSTRAINT [PK_STB] PRIMARY KEY CLUSTERED ([STBId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]-----CREATE PROCEDURE [dbo].[QueryRoomNoFromSTBIP]@STBId char(12) = null,@IPAddress char(15) = nullASIf @STBId is null or @IPAddress is NULLreturn -1If exists (select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress)--STB-1 IP-1Begin--Update the Restart Timeupdate STB set RestartTime=getdate() where STBId = @STBId select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress EndElse if exists (select RoomNo from STB with(NOLOCK) where STBId = @STBId)--STB-1 IP-0 Beginif exists(select STBId from STB with(NOLOCK) where IPAddress = @IPAddress )--STB-Different IP-Yes Beginupdate STB set IPAddress = null, IPUpdated = getdate() where IPAddress = @IPAddressEndupdate STB set IPAddress = @IPAddress, IPUpdated = getdate(), RestartTime=getdate() where STBId = @STBId select RoomNo from STB with(NOLOCK) where STBId = @STBId and IPAddress = @IPAddress EndElse --if not exists(select RoomNo from STB where STBId = @STBId)--STB-0 Beginif exists(select STBId from STB with(NOLOCK) where IPAddress = @IPAddress)--STB-0 IP-1 Beginupdate STB set IPAddress = null, IPUpdated = getdate() where IPAddress = @IPAddressEndinsert into [Config].[dbo].[STB]([STBId] ,[IpAddress],[IPUpdated],[RoomNo],[RestartTime])VALUES(@STBId,@IPAddress,getdate(),'',getdate())End------CREATE Procedure [dbo].[UpdateImageVersion]@STBId char(12),@ImageVersion varchar(10)asUPDATE [Config].[dbo].[STB]SET [ImageVersion] = @ImageVersion,[DeployImageVersion] = nullWHERE STBId = @STBId ----CREATE PROCEDURE [dbo].[HMSQueryGuestMessagesFromSTB]@STBId char (12) = nullASDeclare @RoomNo varchar(10)If @STBId is nullreturn -1select @RoomNo = RoomNo from STB with(NOLOCK) where STBId = @STBIdSELECT HMSGuestMessage.iTVMessageNo as MessageNo,HMSGuestMessage.MessageText as Message_Text,HMSGuestMessage.CurrentStatus as Current_StatusFROM HMSGuestMessage INNER JOIN HMSRoomGuest ON HMSGuestMessage.GuestNo = HMSRoomGuest.GuestNoINNER JOIN STB with(NOLOCK) ON HMSRoomGuest.RoomNo = STB.RoomNoWhere STB.STBId = @STBId and HMSGuestMessage.CurrentStatus <> -1 and HMSRoomGuest.Checkoutdate is nullorder by HMSGuestMessage.CurrentStatus-- Update Guest New Message Flagif @RoomNo is not nullBeginif exists ( select roomno from [Message].[dbo].[GuestMessage] where RoomNo = @RoomNo)Update [Message].[dbo].[GuestMessage] set [GuestMsgFlag] = 0 where RoomNo = @RoomNoelseInsert into [Message].[dbo].[GuestMessage] ([RoomNo] ,[Start] ,[End] ,[GuestMsgFlag])Values ( @RoomNo, Null, Null, 0)End----04/29/2009 10:05:59,spid27s,Unknown,waiter id=processa7ee38 mode=U requestType=wait04/29/2009 10:05:59,spid27s,Unknown,waiter-list04/29/2009 10:05:59,spid27s,Unknown,owner id=processa79b58 mode=X04/29/2009 10:05:59,spid27s,Unknown,owner-list04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lockb6bce80 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:59,spid27s,Unknown,waiter id=processa79b58 mode=U requestType=wait04/29/2009 10:05:59,spid27s,Unknown,waiter-list04/29/2009 10:05:59,spid27s,Unknown,owner id=processd25978 mode=X04/29/2009 10:05:59,spid27s,Unknown,owner-list04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock9277e40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:59,spid27s,Unknown,waiter id=processd25978 mode=U requestType=wait04/29/2009 10:05:59,spid27s,Unknown,waiter-list04/29/2009 10:05:59,spid27s,Unknown,owner id=processa79b58 mode=X04/29/2009 10:05:59,spid27s,Unknown,owner-list04/29/2009 10:05:59,spid27s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock3f71dc0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:59,spid27s,Unknown,resource-list04/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:59,spid27s,Unknown,inputbuf04/29/2009 10:05:59,spid27s,Unknown,--commit transaction04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:59,spid27s,Unknown,executionStack04/29/2009 10:05:59,spid27s,Unknown,process id=processd25978 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4609 ownerId=15507515 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.903 XDES=0x46cd0250 lockMode=U schedulerid=4 kpid=5180 status=suspended spid=61 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.903 lastbatchcompleted=2009-04-29T10:05:54.903 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507515 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:59,spid27s,Unknown,inputbuf04/29/2009 10:05:59,spid27s,Unknown,--commit transaction04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:59,spid27s,Unknown,executionStack04/29/2009 10:05:59,spid27s,Unknown,process id=processa7ee38 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4609 ownerId=15507533 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.920 XDES=0x19990250 lockMode=U schedulerid=3 kpid=1892 status=suspended spid=63 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.920 lastbatchcompleted=2009-04-29T10:05:54.920 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507533 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:59,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:59,spid27s,Unknown,inputbuf04/29/2009 10:05:59,spid27s,Unknown,--commit transaction04/29/2009 10:05:59,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:59,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:59,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:59,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:59,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:59,spid27s,Unknown,executionStack04/29/2009 10:05:59,spid27s,Unknown,process id=processa79b58 taskpriority=0 logused=84 waitresource=RID: 5:1:252:35 waittime=4609 ownerId=15507517 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:54.920 XDES=0x463d378 lockMode=U schedulerid=2 kpid=2752 status=suspended spid=60 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:54.920 lastbatchcompleted=2009-04-29T10:05:54.903 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15507517 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:59,spid27s,Unknown,process-list04/29/2009 10:05:59,spid27s,Unknown,deadlock victim=processd2597804/29/2009 10:05:59,spid27s,Unknown,deadlock-list04/29/2009 10:05:43,spid22s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:43,spid22s,Unknown,waiter-list04/29/2009 10:05:43,spid22s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:43,spid22s,Unknown,owner-list04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:43,spid22s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:43,spid22s,Unknown,waiter-list04/29/2009 10:05:43,spid22s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:43,spid22s,Unknown,owner-list04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:43,spid22s,Unknown,waiter id=processd253d8 mode=U requestType=wait04/29/2009 10:05:43,spid22s,Unknown,waiter-list04/29/2009 10:05:43,spid22s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:43,spid22s,Unknown,owner-list04/29/2009 10:05:43,spid22s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:43,spid22s,Unknown,resource-list04/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:43,spid22s,Unknown,inputbuf04/29/2009 10:05:43,spid22s,Unknown,--commit transaction04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:43,spid22s,Unknown,executionStack04/29/2009 10:05:43,spid22s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4781 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:43,spid22s,Unknown,inputbuf04/29/2009 10:05:43,spid22s,Unknown,--commit transaction04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:43,spid22s,Unknown,executionStack04/29/2009 10:05:43,spid22s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=156 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:43,spid22s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:43,spid22s,Unknown,inputbuf04/29/2009 10:05:43,spid22s,Unknown,--commit transaction04/29/2009 10:05:43,spid22s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:43,spid22s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:43,spid22s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:43,spid22s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:43,spid22s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:43,spid22s,Unknown,executionStack04/29/2009 10:05:43,spid22s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4765 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:43,spid22s,Unknown,process-list04/29/2009 10:05:43,spid22s,Unknown,deadlock victim=processa7fa6804/29/2009 10:05:43,spid22s,Unknown,deadlock-list04/29/2009 10:05:42,spid16s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:42,spid16s,Unknown,waiter-list04/29/2009 10:05:42,spid16s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:42,spid16s,Unknown,owner-list04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid16s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:42,spid16s,Unknown,waiter-list04/29/2009 10:05:42,spid16s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:42,spid16s,Unknown,owner-list04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid16s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:42,spid16s,Unknown,waiter-list04/29/2009 10:05:42,spid16s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:42,spid16s,Unknown,owner-list04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid16s,Unknown,waiter id=processd253d8 mode=U requestType=wait04/29/2009 10:05:42,spid16s,Unknown,waiter-list04/29/2009 10:05:42,spid16s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:42,spid16s,Unknown,owner-list04/29/2009 10:05:42,spid16s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid16s,Unknown,resource-list04/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid16s,Unknown,inputbuf04/29/2009 10:05:42,spid16s,Unknown,--commit transaction04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid16s,Unknown,executionStack04/29/2009 10:05:42,spid16s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4625 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid16s,Unknown,inputbuf04/29/2009 10:05:42,spid16s,Unknown,--commit transaction04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid16s,Unknown,executionStack04/29/2009 10:05:42,spid16s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4609 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid16s,Unknown,inputbuf04/29/2009 10:05:42,spid16s,Unknown,--commit transaction04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid16s,Unknown,executionStack04/29/2009 10:05:42,spid16s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4609 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid16s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid16s,Unknown,inputbuf04/29/2009 10:05:42,spid16s,Unknown,--commit transaction04/29/2009 10:05:42,spid16s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid16s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid16s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid16s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid16s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid16s,Unknown,executionStack04/29/2009 10:05:42,spid16s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4609 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid16s,Unknown,process-list04/29/2009 10:05:42,spid16s,Unknown,deadlock victim=processa7ed4804/29/2009 10:05:42,spid16s,Unknown,deadlock-list04/29/2009 10:05:42,spid14s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,waiter-list04/29/2009 10:05:42,spid14s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:42,spid14s,Unknown,owner-list04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,waiter-list04/29/2009 10:05:42,spid14s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:42,spid14s,Unknown,owner-list04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,waiter id=process9ea5c8 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,waiter-list04/29/2009 10:05:42,spid14s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:42,spid14s,Unknown,owner-list04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,waiter id=processd253d8 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,waiter-list04/29/2009 10:05:42,spid14s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:42,spid14s,Unknown,owner-list04/29/2009 10:05:42,spid14s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,resource-list04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid14s,Unknown,inputbuf04/29/2009 10:05:42,spid14s,Unknown,--commit transaction04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=4312 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:42,spid27s,Unknown,waiter-list04/29/2009 10:05:42,spid27s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,owner-list04/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,inputbuf04/29/2009 10:05:42,spid14s,Unknown,--commit transaction04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid27s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid27s,Unknown,waiter-list04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid27s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,owner-list04/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid14s,Unknown,executionStack04/29/2009 10:05:42,spid27s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:42,spid14s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4296 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,waiter id=process9ea988 mode=U requestType=wait04/29/2009 10:05:42,spid27s,Unknown,waiter-list04/29/2009 10:05:42,spid27s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:42,spid27s,Unknown,owner-list04/29/2009 10:05:42,spid27s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:42,spid27s,Unknown,resource-list04/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,inputbuf04/29/2009 10:05:42,spid14s,Unknown,inputbuf04/29/2009 10:05:42,spid27s,Unknown,--commit transaction04/29/2009 10:05:42,spid14s,Unknown,--commit transaction04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid27s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,executionStack04/29/2009 10:05:42,spid27s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=4296 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid14s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4296 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,inputbuf04/29/2009 10:05:42,spid27s,Unknown,--commit transaction04/29/2009 10:05:42,spid14s,Unknown,inputbuf04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid14s,Unknown,--commit transaction04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid27s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=4296 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,inputbuf04/29/2009 10:05:42,spid27s,Unknown,--commit transaction04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid14s,Unknown,inputbuf04/29/2009 10:05:42,spid14s,Unknown,--commit transaction04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid27s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid14s,Unknown,executionStack04/29/2009 10:05:42,spid14s,Unknown,process id=process9ea5c8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485909 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x447ec250 lockMode=U schedulerid=1 kpid=5684 status=suspended spid=151 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485909 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:42,spid27s,Unknown,inputbuf04/29/2009 10:05:42,spid27s,Unknown,--commit transaction04/29/2009 10:05:42,spid27s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:42,spid14s,Unknown,process-list04/29/2009 10:05:42,spid27s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:42,spid14s,Unknown,deadlock victim=process9ea5c804/29/2009 10:05:42,spid27s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:42,spid14s,Unknown,deadlock-list04/29/2009 10:05:42,spid27s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:42,spid27s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:42,spid27s,Unknown,executionStack04/29/2009 10:05:42,spid27s,Unknown,process id=process9ea988 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=4296 ownerId=15485894 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x45f6d5b8 lockMode=U schedulerid=1 kpid=9360 status=suspended spid=149 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485894 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:42,spid27s,Unknown,process-list04/29/2009 10:05:42,spid27s,Unknown,deadlock victim=process9ea98804/29/2009 10:05:42,spid27s,Unknown,deadlock-list04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,waiter-list04/29/2009 10:05:41,spid20s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:41,spid20s,Unknown,owner-list04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,waiter-list04/29/2009 10:05:41,spid20s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:41,spid20s,Unknown,owner-list04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid20s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,waiter id=processa7ef28 mode=U requestType=wait04/29/2009 10:05:41,spid23s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,waiter-list04/29/2009 10:05:41,spid23s,Unknown,waiter-list04/29/2009 10:05:41,spid20s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:41,spid23s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:41,spid20s,Unknown,owner-list04/29/2009 10:05:41,spid23s,Unknown,owner-list04/29/2009 10:05:41,spid20s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid20s,Unknown,resource-list04/29/2009 10:05:41,spid23s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,waiter-list04/29/2009 10:05:41,spid20s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:41,spid20s,Unknown,--commit transaction04/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid23s,Unknown,owner-list04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid23s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:41,spid23s,Unknown,waiter id=process9eb018 mode=U requestType=wait04/29/2009 10:05:41,spid20s,Unknown,executionStack04/29/2009 10:05:41,spid23s,Unknown,waiter-list04/29/2009 10:05:41,spid20s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=3671 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid23s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:41,spid23s,Unknown,owner-list04/29/2009 10:05:41,spid23s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:41,spid23s,Unknown,resource-list04/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid20s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,executionStack04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid23s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=3671 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,executionStack04/29/2009 10:05:41,spid20s,Unknown,process id=processa7ef28 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485845 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647d888 lockMode=U schedulerid=3 kpid=6540 status=suspended spid=148 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485845 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid20s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,executionStack04/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid23s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=3671 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,executionStack04/29/2009 10:05:41,spid20s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=3671 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid20s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,inputbuf04/29/2009 10:05:41,spid20s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid20s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,executionStack04/29/2009 10:05:41,spid23s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid20s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid20s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid20s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid23s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:41,spid23s,Unknown,inputbuf04/29/2009 10:05:41,spid23s,Unknown,--commit transaction04/29/2009 10:05:41,spid23s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:41,spid23s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:41,spid23s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:41,spid23s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:41,spid23s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:41,spid20s,Unknown,executionStack04/29/2009 10:05:41,spid20s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid23s,Unknown,executionStack04/29/2009 10:05:41,spid23s,Unknown,process id=process9eb018 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=3671 ownerId=15485892 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x46e8a250 lockMode=U schedulerid=1 kpid=6468 status=suspended spid=150 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485892 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:41,spid20s,Unknown,process-list04/29/2009 10:05:41,spid20s,Unknown,deadlock victim=processa7ef2804/29/2009 10:05:41,spid20s,Unknown,deadlock-list04/29/2009 10:05:41,spid23s,Unknown,process-list04/29/2009 10:05:41,spid23s,Unknown,deadlock victim=process9eb01804/29/2009 10:05:41,spid23s,Unknown,deadlock-list04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter-list04/29/2009 10:05:40,spid17s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:40,spid17s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter-list04/29/2009 10:05:40,spid17s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:40,spid17s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter id=processa7fc48 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter-list04/29/2009 10:05:40,spid17s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:40,spid17s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,waiter id=process45c4e2f8 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter id=processd253d8 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,waiter-list04/29/2009 10:05:40,spid17s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:40,spid17s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f6a2c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,resource-list04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,process id=process45c4e2f8 taskpriority=0 logused=84 waitresource=RID: 5:1:183:22 waittime=2421 ownerId=15491937 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:36.373 XDES=0x45d2ac70 lockMode=U schedulerid=2 kpid=4436 status=suspended spid=133 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:36.373 lastbatchcompleted=2009-04-29T10:05:36.373 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15491937 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,process id=processd253d8 taskpriority=0 logused=0 waitresource=RID: 5:1:183:22 waittime=2437 ownerId=15485964 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x450d8250 lockMode=U schedulerid=4 kpid=7268 status=suspended spid=119 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485964 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7fa68 mode=U requestType=wait04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid15s,Unknown,waiter-list04/29/2009 10:05:40,spid15s,Unknown,owner id=processa7ed48 mode=X04/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid15s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,process id=processa7fc48 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485823 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647ce68 lockMode=U schedulerid=3 kpid=7876 status=suspended spid=145 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485823 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f74800 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7ed48 mode=U requestType=wait04/29/2009 10:05:40,spid15s,Unknown,waiter-list04/29/2009 10:05:40,spid15s,Unknown,owner id=processa78c58 mode=X04/29/2009 10:05:40,spid15s,Unknown,owner-list04/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=608 dbid=5 objectname=Config.dbo.STB id=lock92d96c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa78c58 mode=U requestType=wait04/29/2009 10:05:40,spid15s,Unknown,waiter id=processa7f108 mode=U requestType=wait04/29/2009 10:05:40,spid15s,Unknown,waiter-list04/29/2009 10:05:40,spid15s,Unknown,owner id=processa7fa68 mode=X04/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid15s,Unknown,owner-list04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock3f71d40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid15s,Unknown,resource-list04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid15s,Unknown,inputbuf04/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=2421 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid15s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid15s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid15s,Unknown,process id=processa7fa68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:40 waittime=2421 ownerId=15485766 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.997 XDES=0x46465b58 lockMode=U schedulerid=3 kpid=4280 status=suspended spid=144 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.997 lastbatchcompleted=2009-04-29T10:05:32.997 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485766 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=2421 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid15s,Unknown,inputbuf04/29/2009 10:05:40,spid15s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid17s,Unknown,inputbuf04/29/2009 10:05:40,spid15s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,process id=processa7f108 taskpriority=0 logused=0 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485814 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.013 XDES=0x4647c8c8 lockMode=U schedulerid=3 kpid=10236 status=suspended spid=146 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.013 lastbatchcompleted=2009-04-29T10:05:33.013 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485814 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,executionStack04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid17s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid15s,Unknown,inputbuf04/29/2009 10:05:40,spid15s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid17s,Unknown,process-list04/29/2009 10:05:40,spid15s,Unknown,executionStack04/29/2009 10:05:40,spid17s,Unknown,deadlock victim=processa7fc4804/29/2009 10:05:40,spid15s,Unknown,process id=processa7ed48 taskpriority=0 logused=84 waitresource=RID: 5:1:608:1 waittime=2421 ownerId=15485653 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.980 XDES=0x464646d0 lockMode=U schedulerid=3 kpid=5580 status=suspended spid=143 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.980 lastbatchcompleted=2009-04-29T10:05:32.980 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485653 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid17s,Unknown,deadlock-list04/29/2009 10:05:40,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:40,spid15s,Unknown,inputbuf04/29/2009 10:05:40,spid15s,Unknown,--commit transaction04/29/2009 10:05:40,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:40,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:40,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:40,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:40,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:40,spid15s,Unknown,executionStack04/29/2009 10:05:40,spid15s,Unknown,process id=processa78c58 taskpriority=0 logused=84 waitresource=RID: 5:1:183:84 waittime=2421 ownerId=15485915 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:33.030 XDES=0x47881b10 lockMode=U schedulerid=2 kpid=10208 status=suspended spid=117 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:33.030 lastbatchcompleted=2009-04-29T10:05:33.030 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15485915 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:40,spid15s,Unknown,process-list04/29/2009 10:05:40,spid15s,Unknown,deadlock victim=processa7f10804/29/2009 10:05:40,spid15s,Unknown,deadlock-list04/29/2009 10:05:38,spid14s,Unknown,waiter id=process9eab68 mode=U requestType=wait04/29/2009 10:05:38,spid14s,Unknown,waiter-list04/29/2009 10:05:38,spid14s,Unknown,owner id=processd24898 mode=X04/29/2009 10:05:38,spid14s,Unknown,owner-list04/29/2009 10:05:38,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:38,spid14s,Unknown,waiter id=processd24898 mode=U requestType=wait04/29/2009 10:05:38,spid14s,Unknown,waiter-list04/29/2009 10:05:38,spid14s,Unknown,owner id=process9eab68 mode=X04/29/2009 10:05:38,spid14s,Unknown,owner-list04/29/2009 10:05:38,spid14s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:38,spid14s,Unknown,resource-list04/29/2009 10:05:38,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:38,spid14s,Unknown,inputbuf04/29/2009 10:05:38,spid14s,Unknown,--commit transaction04/29/2009 10:05:38,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:38,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:38,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:38,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:38,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:38,spid14s,Unknown,executionStack04/29/2009 10:05:38,spid14s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=5000 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:38,spid14s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:38,spid14s,Unknown,inputbuf04/29/2009 10:05:38,spid14s,Unknown,--commit transaction04/29/2009 10:05:38,spid14s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:38,spid14s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:38,spid14s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:38,spid14s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:38,spid14s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:38,spid14s,Unknown,executionStack04/29/2009 10:05:38,spid14s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=5406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:38,spid14s,Unknown,process-list04/29/2009 10:05:38,spid14s,Unknown,deadlock victim=processd2489804/29/2009 10:05:38,spid14s,Unknown,deadlock-list04/29/2009 10:05:33,spid17s,Unknown,waiter id=processa79f18 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eae38 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lockbfd8480 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=process9eae38 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter id=processd24b68 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=processd25a68 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock9589a40 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=processd25a68 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=process9ebf18 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock75161c0 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=process9ebf18 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter id=processa79a68 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eab68 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=183 dbid=5 objectname=Config.dbo.STB id=lock927d900 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=process9eab68 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=processd24898 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=processd24898 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=process9ebd38 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock927c940 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,waiter id=process9ebd38 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,owner id=process9eab68 mode=X04/29/2009 10:05:33,spid17s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,resource-list04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=processd25a68 taskpriority=0 logused=84 waitresource=RID: 5:1:183:56 waittime=406 ownerId=15484003 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x3e462250 lockMode=U schedulerid=4 kpid=8560 status=suspended spid=69 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484003 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=processd24b68 taskpriority=0 logused=0 waitresource=RID: 5:1:183:25 waittime=406 ownerId=15484005 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x3c412d90 lockMode=U schedulerid=4 kpid=6444 status=suspended spid=82 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484005 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:15 waittime=421 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=processa79f18 taskpriority=0 logused=0 waitresource=RID: 5:1:183:8 waittime=500 ownerId=15484461 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.717 XDES=0x443bc8c8 lockMode=U schedulerid=2 kpid=5452 status=suspended spid=87 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.717 lastbatchcompleted=2009-04-29T10:05:32.717 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484461 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=processa79a68 taskpriority=0 logused=0 waitresource=RID: 5:1:183:61 waittime=421 ownerId=15483956 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x443bd600 lockMode=U schedulerid=2 kpid=4516 status=suspended spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483956 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=process9ebf18 taskpriority=0 logused=84 waitresource=RID: 5:1:183:61 waittime=406 ownerId=15484001 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.637 XDES=0x47549888 lockMode=U schedulerid=1 kpid=6240 status=suspended spid=94 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.637 lastbatchcompleted=2009-04-29T10:05:32.637 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484001 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=process9ebd38 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=406 ownerId=15483868 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x46e8b210 lockMode=U schedulerid=1 kpid=6808 status=suspended spid=77 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.607 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483868 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,waiter id=process9eab68 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid15s,Unknown,waiter id=processa78e38 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid15s,Unknown,waiter-list04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid15s,Unknown,owner id=processd24898 mode=X04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid15s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3f80f80 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid15s,Unknown,waiter id=processd24898 mode=U requestType=wait04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid15s,Unknown,waiter-list04/29/2009 10:05:33,spid15s,Unknown,owner id=process9ebd38 mode=X04/29/2009 10:05:33,spid15s,Unknown,owner-list04/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock927c940 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid17s,Unknown,process id=process9eae38 taskpriority=0 logused=84 waitresource=RID: 5:1:183:25 waittime=406 ownerId=15484457 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.717 XDES=0x46f2a250 lockMode=U schedulerid=1 kpid=5992 status=suspended spid=85 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.717 lastbatchcompleted=2009-04-29T10:05:32.717 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15484457 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,waiter id=process9ebd38 mode=U requestType=wait04/29/2009 10:05:33,spid15s,Unknown,waiter-list04/29/2009 10:05:33,spid15s,Unknown,owner id=process9eab68 mode=X04/29/2009 10:05:33,spid15s,Unknown,owner-list04/29/2009 10:05:33,spid15s,Unknown,ridlock fileid=1 pageid=252 dbid=5 objectname=Config.dbo.STB id=lock3e60480 mode=X associatedObjectId=7205759404166348804/29/2009 10:05:33,spid15s,Unknown,resource-list04/29/2009 10:05:33,spid17s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid17s,Unknown,inputbuf04/29/2009 10:05:33,spid15s,Unknown,inputbuf04/29/2009 10:05:33,spid17s,Unknown,--commit transaction04/29/2009 10:05:33,spid15s,Unknown,--commit transaction04/29/2009 10:05:33,spid17s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid17s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid17s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid17s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid17s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid17s,Unknown,executionStack04/29/2009 10:05:33,spid15s,Unknown,executionStack04/29/2009 10:05:33,spid17s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,process id=processd24898 taskpriority=0 logused=84 waitresource=RID: 5:1:252:15 waittime=421 ownerId=15483884 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x3c4127f0 lockMode=U schedulerid=4 kpid=8428 status=suspended spid=78 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483884 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid17s,Unknown,process-list04/29/2009 10:05:33,spid17s,Unknown,deadlock victim=process9ebd3804/29/2009 10:05:33,spid17s,Unknown,deadlock-list04/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid15s,Unknown,inputbuf04/29/2009 10:05:33,spid15s,Unknown,--commit transaction04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid15s,Unknown,executionStack04/29/2009 10:05:33,spid15s,Unknown,process id=processa78e38 taskpriority=0 logused=0 waitresource=RID: 5:1:252:14 waittime=421 ownerId=15483934 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x454aa6d0 lockMode=U schedulerid=2 kpid=8980 status=suspended spid=92 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483934 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid15s,Unknown,inputbuf04/29/2009 10:05:33,spid15s,Unknown,--commit transaction04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid15s,Unknown,executionStack04/29/2009 10:05:33,spid15s,Unknown,process id=process9ebd38 taskpriority=0 logused=84 waitresource=RID: 5:1:252:55 waittime=406 ownerId=15483868 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x46e8b210 lockMode=U schedulerid=1 kpid=6808 status=suspended spid=77 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.607 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483868 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,Proc [Database Id = 5 Object Id = 2030630277]04/29/2009 10:05:33,spid15s,Unknown,inputbuf04/29/2009 10:05:33,spid15s,Unknown,--commit transaction04/29/2009 10:05:33,spid15s,Unknown,WHERE STBId = @STBId04/29/2009 10:05:33,spid15s,Unknown,[DeployImageVersion] = null04/29/2009 10:05:33,spid15s,Unknown,SET [ImageVersion] = @ImageVersion04/29/2009 10:05:33,spid15s,Unknown,UPDATE [Config].[dbo].[STB]04/29/2009 10:05:33,spid15s,Unknown,frame procname=Config.dbo.UpdateImageVersion line=7 stmtstart=328 sqlhandle=0x0300050085f50879c7c3db00f39b0000010000000000000004/29/2009 10:05:33,spid15s,Unknown,executionStack04/29/2009 10:05:33,spid15s,Unknown,process id=process9eab68 taskpriority=0 logused=84 waitresource=RID: 5:1:252:14 waittime=406 ownerId=15483947 transactionname=UPDATE lasttranstarted=2009-04-29T10:05:32.623 XDES=0x47548e68 lockMode=U schedulerid=1 kpid=8168 status=suspended spid=93 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2009-04-29T10:05:32.623 lastbatchcompleted=2009-04-29T10:05:32.623 hostname=ITVSERVER-1 hostpid=2368 loginname=AppLogin isolationlevel=read committed (2) xactid=15483947 currentdb=5 lockTimeout=4294967295 clientoption1=671088672 clientoption2=12805604/29/2009 10:05:33,spid15s,Unknown,process-list04/29/2009 10:05:33,spid15s,Unknown,deadlock victim=processa78e3804/29/2009 10:05:33,spid15s,Unknown,deadlock-list

Performance Issues on Insert with table contained in Full Text Search

pamozer — Wed, 27 Feb 2013 09:02:17 GMT

I have the following tableThis tables gets around 650,000 Inserts per day and some of these inserts are taking over 1 second. There is a full text index On ChangeSet, EntityTypeText, SubEntityTypeText, And UserName.The execution plan that follows is crazy.So one question I have is that it looks like the application that is doing the inserts in using nvarchar while the table datatypes are varchar. This would cause implicit conversions correct? And could be part of the issue of why the insert takes so long? Also is the plan that crazy just because its part of a full text index?This insert is causing blocking and long waits( write log waits and exclusive locks). Please let me know if you need more information. THANKS[code="sql"]CREATE TABLE [dbo].[AuditLog]( [AuditLogID] [bigint] IDENTITY(1,1) NOT NULL, [Application] [varchar](50) NOT NULL, [AuditActionTypeID] [int] NOT NULL, [AuditTypeID] [int] NOT NULL, [ChangeSet] [xml] NULL, [EntityTypeId] [int] NOT NULL, [EntityTypeText] [varchar](100) NULL, [SubEntityTypeId] [int] NULL, [SubEntityTypeText] [varchar](100) NULL, [CustomerId] [int] NOT NULL, [PracticeId] [int] NULL, [UserId] [int] NOT NULL, [UserName] [varchar](50) NOT NULL, [CreatedDate] [datetime] NOT NULL, CONSTRAINT [PK_AuditLog] PRIMARY KEY CLUSTERED ( [AuditLogID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO/****** Object: Index [IX_AuditLog_CustomerID_PracticeID_CreatedDate] Script Date: 02/27/2013 07:45:59 ******/CREATE NONCLUSTERED INDEX [IX_AuditLog_CustomerID_PracticeID_CreatedDate] ON [dbo].[AuditLog] ( [CustomerId] ASC, [PracticeId] ASC, [CreatedDate] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOCREATE NONCLUSTERED INDEX [IX_AuditLog_EntityTypeID_CustomerID_PracticeID_AuditTypeID] ON [dbo].[AuditLog] ( [EntityTypeId] ASC, [CustomerId] ASC, [PracticeId] ASC, [AuditTypeID] ASC, [CreatedDate] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]GOCREATE NONCLUSTERED INDEX [IX_AuditLog_SubEntityTypeID_CustomerID_PracticeID_AuditTypeID] ON [dbo].[AuditLog] ( [SubEntityTypeId] ASC, [CustomerId] ASC, [PracticeId] ASC, [AuditTypeID] ASC, [CreatedDate] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]GOALTER TABLE [dbo].[AuditLog] WITH CHECK ADD CONSTRAINT [FK_AuditLog_AuditActionType] FOREIGN KEY([AuditActionTypeID])REFERENCES [dbo].[AuditActionType] ([AuditActionTypeID])GOALTER TABLE [dbo].[AuditLog] CHECK CONSTRAINT [FK_AuditLog_AuditActionType]GOALTER TABLE [dbo].[AuditLog] WITH CHECK ADD CONSTRAINT [FK_AuditLog_AuditType] FOREIGN KEY([AuditTypeID])REFERENCES [dbo].[AuditType] ([AuditTypeID])GOALTER TABLE [dbo].[AuditLog] CHECK CONSTRAINT [FK_AuditLog_AuditType]GO[/code][b]INSERT STATEMENT[/b][code="sql"](@Application nvarchar(4000),@AuditActionTypeID int,@AuditTypeID int,@ChangeSet nvarchar(4000), @CreatedDate datetime,@CustomerId int,@EntityTypeId int, @EntityTypeText nvarchar(4000),@PracticeId int,@SubEntityTypeId int,@SubEntityTypeText nvarchar(4000),@UserId int,@UserName nvarchar(4000)) INSERT INTO dbo.AuditLog ( Application , AuditActionTypeID , AuditTypeID , ChangeSet , EntityTypeId , EntityTypeText , SubEntityTypeId , SubEntityTypeText , CustomerId , PracticeId , UserId , UserName , CreatedDate ) VALUES ( @Application , -- Application - varchar(50) @AuditActionTypeID , -- AuditActionTypeID - int @AuditTypeID , -- AuditTypeID - int @Changeset , -- ChangeSet - xml @EntityTypeID , -- EntityTypeId - int @EntityTypeText , -- EntityTypeText - varchar(100) @SubEntityTypeID , -- SubEntityTypeId - int @SubEntityTypeText , -- SubEntityTypeText - varchar(100) @CustomerID , -- CustomerId - int @PracticeID, -- PracticeId - int @UserID, -- UserId - int @UserName, -- UserName - varchar(50) @CreatedDate -- CreatedDate - datetime )[/code][b]EXECUTION PLAN[/b][code="xml"]<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.0" Build="9.00.5292.00"> <BatchSequence> <Batch> <Statements> <StmtSimple StatementText="(@Application nvarchar(4000),@AuditActionTypeID int,@AuditTypeID int,@ChangeSet nvarchar(4000),@CreatedDate datetime,@CustomerId int,@EntityTypeId int,@EntityTypeText nvarchar(4000),@PracticeId int,@SubEntityTypeId int,@SubEntityTypeText nvarchar(4000),@UserId int,@UserName nvarchar(4000))INSERT INTO dbo.AuditLog ( Application , AuditActionTypeID , AuditTypeID , ChangeSet , EntityTypeId , EntityTypeText , SubEntityTypeId , SubEntityTypeText , CustomerId , PracticeId , UserId , UserName , CreatedDate ) VALUES ( @Application , -- Application - varchar(50) @AuditActionTypeID , -- AuditActionTypeID - int @AuditTypeID , -- AuditTypeID - int @Changeset , -- ChangeSet - xml @EntityTypeID , -- EntityTypeId - int @EntityTypeText , -- EntityTypeText - varchar(100) @SubEntityTypeID , -- SubEntityTypeId - int @SubEntityTypeText , -- SubEntityTypeText - varchar(100) @CustomerID , -- CustomerId - int @PracticeID, -- PracticeId - int @UserID, -- UserId - int @UserName, -- UserName - varchar(50) @CreatedDate -- CreatedDate - datetime ) " StatementId="1" StatementCompId="1" StatementType="INSERT" StatementSubTreeCost="0.0931649" StatementEstRows="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound"> <QueryPlan CachedPlanSize="135" CompileTime="5" CompileCPU="5" CompileMemory="872"> <RelOp NodeId="1" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0931649" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <Assert StartupExpression="0"> <RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0931647" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="Expr1040" /> <ColumnReference Column="Expr1041" /> </OutputList> <NestedLoops Optimized="0"> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1041" /> </DefinedValue> </DefinedValues> <OuterReferences> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> </OuterReferences> <ProbeColumn> <ColumnReference Column="Expr1041" /> </ProbeColumn> <RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0898774" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ColumnReference Column="Expr1040" /> </OutputList> <NestedLoops Optimized="0"> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1040" /> </DefinedValue> </DefinedValues> <OuterReferences> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> </OuterReferences> <ProbeColumn> <ColumnReference Column="Expr1040" /> </ProbeColumn> <RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0865901" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> </OutputList> <NestedLoops Optimized="0"> <OuterReferences> <ColumnReference Column="Expr1042" /> <ColumnReference Column="Expr1030" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </OuterReferences> <RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="482" EstimatedTotalSubtreeCost="0.0465804" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ColumnReference Column="Expr1042" /> <ColumnReference Column="Expr1030" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </OutputList> <NestedLoops Optimized="0"> <PassThru> <ScalarOperator ScalarString="[IsBaseRow1032] IS NULL"> <Compare CompareOp="IS"> <ScalarOperator> <Identifier> <ColumnReference Column="IsBaseRow1032" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Compare> </ScalarOperator> </PassThru> <OuterReferences> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </OuterReferences> <RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="482" EstimatedTotalSubtreeCost="0.0432928" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ColumnReference Column="Expr1042" /> <ColumnReference Column="Expr1030" /> <ColumnReference Column="IsBaseRow1032" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </OutputList> <NestedLoops Optimized="0"> <OuterReferences> <ColumnReference Column="Expr1042" /> </OuterReferences> <RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="477" EstimatedTotalSubtreeCost="0.0400056" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ColumnReference Column="Expr1042" /> <ColumnReference Column="Expr1030" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1042" /> <ScalarOperator ScalarString="[Expr1042]"> <Identifier> <ColumnReference Column="Expr1042" /> </Identifier> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1030" /> <ScalarOperator ScalarString="gettimestamp((9))"> <Intrinsic FunctionName="gettimestamp"> <ScalarOperator> <Const ConstValue="(9)" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="469" EstimatedTotalSubtreeCost="0.0400055" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ColumnReference Column="Expr1042" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1042" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(varbinary(900),[KareoAudit].[dbo].[AuditLog].[AuditLogID],0)"> <Convert DataType="varbinary" Length="900" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditLogID" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp NodeId="9" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.04" EstimateCPU="4e-006" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0400054" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditLogID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> </OutputList> <Update> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Index="[PK_AuditLog]" /> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Index="[IX_AuditLog_EntityTypeID_CustomerID_PracticeID_AuditTypeID]" /> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Index="[IX_AuditLog_CustomerID_PracticeID_CreatedDate]" /> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Index="[IX_AuditLog_SubEntityTypeID_CustomerID_PracticeID_AuditTypeID]" /> <SetPredicate> <ScalarOperator ScalarString="[KareoAudit].[dbo].[AuditLog].[Application] = RaiseIfNull([Expr1004]),[KareoAudit].[dbo].[AuditLog].[AuditActionTypeID] = RaiseIfNull([@AuditActionTypeID]),[KareoAudit].[dbo].[AuditLog].[AuditTypeID] = RaiseIfNull([@AuditTypeID]),[KareoAudit].[dbo].[AuditLog].[ChangeSet] = [Expr1005],[KareoAudit].[dbo].[AuditLog].[EntityTypeId] = RaiseIfNull([@EntityTypeId]),[KareoAudit].[dbo].[AuditLog].[EntityTypeText] = [Expr1006],[KareoAudit].[dbo].[AuditLog].[SubEntityTypeId] = [@SubEntityTypeId],[KareoAudit].[dbo].[AuditLog].[SubEntityTypeText] = [Expr1007],[KareoAudit].[dbo].[AuditLog].[CustomerId] = RaiseIfNull([@CustomerId]),[KareoAudit].[dbo].[AuditLog].[PracticeId] = [@PracticeId],[KareoAudit].[dbo].[AuditLog].[UserId] = RaiseIfNull([@UserId]),[KareoAudit].[dbo].[AuditLog].[UserName] = RaiseIfNull([Expr1008]),[KareoAudit].[dbo].[AuditLog].[CreatedDate] = RaiseIfNull([@CreatedDate]),[KareoAudit].[dbo].[AuditLog].[AuditLogID] = [Expr1003]"> <ScalarExpressionList> <ScalarOperator> <MultipleAssign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="Application" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1004" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@AuditActionTypeID" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@AuditTypeID" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="ChangeSet" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1005" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="EntityTypeId" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@EntityTypeId" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="EntityTypeText" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1006" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="SubEntityTypeId" /> <ScalarOperator> <Identifier> <ColumnReference Column="@SubEntityTypeId" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="SubEntityTypeText" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1007" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="CustomerId" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@CustomerId" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="PracticeId" /> <ScalarOperator> <Identifier> <ColumnReference Column="@PracticeId" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="UserId" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@UserId" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="UserName" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1008" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="CreatedDate" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="@CreatedDate" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditLogID" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1003" /> </Identifier> </ScalarOperator> </Assign> </MultipleAssign> </ScalarOperator> </ScalarExpressionList> </ScalarOperator> </SetPredicate> <RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="1233" EstimatedTotalSubtreeCost="1.357e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="Expr1003" /> <ColumnReference Column="Expr1004" /> <ColumnReference Column="Expr1005" /> <ColumnReference Column="Expr1006" /> <ColumnReference Column="Expr1007" /> <ColumnReference Column="Expr1008" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1004" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(50),[@Application],0)"> <Convert DataType="varchar" Length="50" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Column="@Application" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1005" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(xml,[@ChangeSet],0)"> <Convert DataType="xml" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Column="@ChangeSet" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1006" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(100),[@EntityTypeText],0)"> <Convert DataType="varchar" Length="100" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Column="@EntityTypeText" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1007" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(100),[@SubEntityTypeText],0)"> <Convert DataType="varchar" Length="100" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Column="@SubEntityTypeText" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1008" /> <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(50),[@UserName],0)"> <Convert DataType="varchar" Length="50" Style="0" Implicit="1"> <ScalarOperator> <Identifier> <ColumnReference Column="@UserName" /> </Identifier> </ScalarOperator> </Convert> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="15" EstimatedTotalSubtreeCost="1.257e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="Expr1003" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1003" /> <ScalarOperator ScalarString="getidentity((2073058421),(9),NULL)"> <Intrinsic FunctionName="getidentity"> <ScalarOperator> <Const ConstValue="(2073058421)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="(9)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp NodeId="12" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <ConstantScan /> </RelOp> </ComputeScalar> </RelOp> </ComputeScalar> </RelOp> </Update> </RelOp> </ComputeScalar> </RelOp> </ComputeScalar> </RelOp> <RelOp NodeId="35" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="IsBaseRow1032" /> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </OutputList> <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0"> <DefinedValues> <DefinedValue> <ColumnReference Column="IsBaseRow1032" /> </DefinedValue> <DefinedValue> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </DefinedValue> </DefinedValues> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i2]" /> <SeekPredicates> <SeekPredicate> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="ftkey" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[Expr1042]"> <Identifier> <ColumnReference Column="Expr1042" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekPredicate> </SeekPredicates> </IndexScan> </RelOp> </NestedLoops> </RelOp> <RelOp NodeId="37" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </OutputList> <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0"> <DefinedValues> <DefinedValue> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </DefinedValue> </DefinedValues> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i1]" TableReferenceId="-1" /> <SeekPredicates> <SeekPredicate> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[KareoAudit].[sys].[fulltext_index_map_2073058421].[docid]"> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekPredicate> </SeekPredicates> </IndexScan> </RelOp> </NestedLoops> </RelOp> <RelOp NodeId="41" PhysicalOp="Switch" LogicalOp="Switch" EstimateRows="1" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0400055" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <Switch> <DefinedValues /> <RelOp NodeId="42" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="1" EstimateIO="0" EstimateCPU="1.8e-007" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0400053" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <Assert StartupExpression="0"> <RelOp NodeId="43" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.04" EstimateCPU="4e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0400052" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <Update> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i1]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i2]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i3]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i4]" /> <SetPredicate> <ScalarOperator ScalarString="[KareoAudit].[sys].[fulltext_index_map_2073058421].[status] = RaiseIfNull([Expr1035]),[KareoAudit].[sys].[fulltext_index_map_2073058421].[ts] = RaiseIfNull([Expr1030])"> <ScalarExpressionList> <ScalarOperator> <MultipleAssign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1035" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="ts" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1030" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> </MultipleAssign> </ScalarOperator> </ScalarExpressionList> </ScalarOperator> </SetPredicate> <RelOp NodeId="44" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="Expr1035" /> </OutputList> <ConstantScan> <Values> <Row> <ScalarOperator ScalarString="CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(1) THEN (1) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(152) THEN (144) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(208) THEN (144) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(144) THEN (144) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(8) THEN (1) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(0) THEN (0) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(184) THEN (176) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(240) THEN (176) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(176) THEN (176) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(2) THEN (1) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(192) THEN (128) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(128) THEN (128) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(3) THEN (0) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(224) THEN (160) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(160) THEN (160) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(4) THEN (0) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(5) THEN (0) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(6) THEN (0) ELSE CASE WHEN [KareoAudit].[sys].[fulltext_index_map_2073058421].[status]=(7) THEN (0) ELSE [KareoAudit].[sys].[fulltext_index_map_2073058421].[status] END END END END END END END END END END END END END END END END END END END"> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(1)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(1)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(152)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(144)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(208)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(144)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(144)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(144)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(8)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(1)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(184)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(176)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(240)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(176)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(176)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(176)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(2)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(1)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(192)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(128)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(128)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(128)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(3)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(224)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(160)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(160)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(160)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(4)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(5)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(6)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Compare CompareOp="EQ"> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> <ScalarOperator> <Const ConstValue="(7)" /> </ScalarOperator> </Compare> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> </Identifier> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Row> </Values> </ConstantScan> </RelOp> </Update> </RelOp> <Predicate> <ScalarOperator ScalarString="CASE WHEN fulltextnotify((9),(6),(2073058421),[Expr1042]) IS NOT NULL THEN (0) ELSE NULL END"> <IF> <Condition> <ScalarOperator> <Logical Operation="IS NOT NULL"> <ScalarOperator> <Intrinsic FunctionName="fulltextnotify"> <ScalarOperator> <Const ConstValue="(9)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="(6)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="(2073058421)" /> </ScalarOperator> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1042" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Logical> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Else> </IF> </ScalarOperator> </Predicate> </Assert> </RelOp> <RelOp NodeId="47" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.04" EstimateCPU="4e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0400053" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <Update> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i1]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i2]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i3]" /> <Object Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Index="[i4]" /> <SetPredicate> <ScalarOperator ScalarString="[KareoAudit].[sys].[fulltext_index_map_2073058421].[docid] = [Expr1038],[KareoAudit].[sys].[fulltext_index_map_2073058421].[status] = [Expr1039],[KareoAudit].[sys].[fulltext_index_map_2073058421].[ftkey] = RaiseIfNull([Expr1042]),[KareoAudit].[sys].[fulltext_index_map_2073058421].[ts] = RaiseIfNull([Expr1030])"> <ScalarExpressionList> <ScalarOperator> <MultipleAssign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="docid" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1038" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="status" /> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1039" /> </Identifier> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="ftkey" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1042" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> <Assign> <ColumnReference Database="[KareoAudit]" Schema="[sys]" Table="[fulltext_index_map_2073058421]" Column="ts" /> <ScalarOperator> <Intrinsic FunctionName="RaiseIfNull"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1030" /> </Identifier> </ScalarOperator> </Intrinsic> </ScalarOperator> </Assign> </MultipleAssign> </ScalarOperator> </ScalarExpressionList> </ScalarOperator> </SetPredicate> <RelOp NodeId="48" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="12" EstimatedTotalSubtreeCost="1.257e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList> <ColumnReference Column="Expr1038" /> <ColumnReference Column="Expr1039" /> </OutputList> <ComputeScalar> <DefinedValues> <DefinedValue> <ColumnReference Column="Expr1038" /> <ScalarOperator ScalarString="fulltextnotify((9),(6),(2073058421),NULL)"> <Intrinsic FunctionName="fulltextnotify"> <ScalarOperator> <Const ConstValue="(9)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="(6)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="(2073058421)" /> </ScalarOperator> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Intrinsic> </ScalarOperator> </DefinedValue> <DefinedValue> <ColumnReference Column="Expr1039" /> <ScalarOperator ScalarString="(0)"> <Const ConstValue="(0)" /> </ScalarOperator> </DefinedValue> </DefinedValues> <RelOp NodeId="49" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <ConstantScan /> </RelOp> </ComputeScalar> </RelOp> </Update> </RelOp> </Switch> </RelOp> </NestedLoops> </RelOp> <RelOp NodeId="55" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0"> <DefinedValues /> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditActionType]" Index="[PK_AuditActionType]" /> <SeekPredicates> <SeekPredicate> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditActionType]" Column="AuditActionTypeID" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[KareoAudit].[dbo].[AuditLog].[AuditActionTypeID]"> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditActionTypeID" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekPredicate> </SeekPredicates> </IndexScan> </RelOp> </NestedLoops> </RelOp> <RelOp NodeId="56" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" Parallel="0" EstimateRebinds="0" EstimateRewinds="0"> <OutputList /> <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" NoExpandHint="0"> <DefinedValues /> <Object Database="[KareoAudit]" Schema="[dbo]" Table="[AuditType]" Index="[PK_AuditType]" /> <SeekPredicates> <SeekPredicate> <Prefix ScanType="EQ"> <RangeColumns> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditType]" Column="AuditTypeID" /> </RangeColumns> <RangeExpressions> <ScalarOperator ScalarString="[KareoAudit].[dbo].[AuditLog].[AuditTypeID]"> <Identifier> <ColumnReference Database="[KareoAudit]" Schema="[dbo]" Table="[AuditLog]" Column="AuditTypeID" /> </Identifier> </ScalarOperator> </RangeExpressions> </Prefix> </SeekPredicate> </SeekPredicates> </IndexScan> </RelOp> </NestedLoops> </RelOp> <Predicate> <ScalarOperator ScalarString="CASE WHEN [Expr1040] IS NULL THEN (0) ELSE CASE WHEN [Expr1041] IS NULL THEN (1) ELSE NULL END END"> <IF> <Condition> <ScalarOperator> <Logical Operation="IS NULL"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1040" /> </Identifier> </ScalarOperator> </Logical> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(0)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <IF> <Condition> <ScalarOperator> <Logical Operation="IS NULL"> <ScalarOperator> <Identifier> <ColumnReference Column="Expr1041" /> </Identifier> </ScalarOperator> </Logical> </ScalarOperator> </Condition> <Then> <ScalarOperator> <Const ConstValue="(1)" /> </ScalarOperator> </Then> <Else> <ScalarOperator> <Const ConstValue="NULL" /> </ScalarOperator> </Else> </IF> </ScalarOperator> </Else> </IF> </ScalarOperator> </Predicate> </Assert> </RelOp> <ParameterList> <ColumnReference Column="@CreatedDate" ParameterCompiledValue="'2013-02-27 04:51:19.847'" /> <ColumnReference Column="@UserName" ParameterCompiledValue="N'Test User'" /> <ColumnReference Column="@UserId" ParameterCompiledValue="(64935)" /> <ColumnReference Column="@PracticeId" ParameterCompiledValue="(1)" /> <ColumnReference Column="@CustomerId" ParameterCompiledValue="(14391)" /> <ColumnReference Column="@SubEntityTypeText" ParameterCompiledValue="NULL" /> <ColumnReference Column="@SubEntityTypeId" ParameterCompiledValue="(0)" /> <ColumnReference Column="@EntityTypeText" ParameterCompiledValue="N'Marie Carter'" /> <ColumnReference Column="@EntityTypeId" ParameterCompiledValue="(78)" /> <ColumnReference Column="@ChangeSet" ParameterCompiledValue="NULL" /> <ColumnReference Column="@AuditTypeID" ParameterCompiledValue="(2)" /> <ColumnReference Column="@AuditActionTypeID" ParameterCompiledValue="(2)" /> <ColumnReference Column="@Application" ParameterCompiledValue="N'Audit Adapter'" /> </ParameterList> </QueryPlan> </StmtSimple> </Statements> </Batch> </BatchSequence></ShowPlanXML>[/code]

How to Use SQL Profiler

thbaig1 — Tue, 19 Feb 2013 05:48:25 GMT

Hi,I want to trace all sql,stored proc with sql server profiler. So that I may able to extract top resource consuming components.I have created a template with with following selection[b]Performance [/b]Performance StatisticsShowPlanAllShowPlanXML[b]TSQL[/b]SQL batch completedSql batchStartingSql StmtCompletedSql StmtStartingCan you please suggest1- is above selection enough or should add or remove some options ?2- I ran trace with above and stored results in a table. But was not able to extract use full info.I think I don't know which column to group etc to find costly query in term of read,write or time.Kindly guide me how should I read trace table to extract required information?thanks

Client-Side Tracing: How?

wayne_dyck — Wed, 20 Feb 2013 11:08:55 GMT

Hi,Is there a way to do client-side tracing of the SQL commands being sent from a client box to a SQL Server server without using the SQL Profiler or the sp_trace* stored procedures?I have a packaged application that is poorly documented and has poor reporting capabilities. I need to write queries against the database tables, in some cases without knowing what tables I'm even dealing with. The outsourced IT company managing our servers has been uncooperative with my requests for access to either the SQL Profiler or the underlying stored procedures.I'd like to be able to capture the SQL passing from the client app to the server when I perform a function in the app in order to jump-start the process of identifying the table(s) involved in the particular form I'm working in. Once I know the tables and a bit of the SQL, I would be better positioned to write my own customized versions of the queries.Can this be done?Thanks for any help you can give.Wayne

Query Cost

Minnu — Wed, 20 Feb 2013 03:18:17 GMT

Hi Team,As per my knowledge "Query Cost is a measure of the CPU and input-output resources used by the query"but when am using a small query "select * from student where stud_id=1050"in "Execution plan" window query cost is showing as 100%,Reason please.....

Performence on the basis of Column Names.

nitin.varshney — Mon, 18 Feb 2013 07:17:21 GMT

Is there will any impact on the performence if the name of the temp table/table variable column's like [30-40], [Weightage Calculation], [Start Range] etc.

performance related question

Oracle_91 — Wed, 13 Feb 2013 05:56:21 GMT

Hi All,I have a question on performance tuning approach and where should i start and what should be my approach on below.All of sudden, all of my queries started performing very slow. What can i do even before going to profiler tracing..Looking for more inputs.Thanks in advance.

HOw to get Automatic Email notification for High CPU Utilization >80 % with the query which is causing the high CPU usage

Ivan Mohapatra — Mon, 11 Feb 2013 04:29:11 GMT

hi all,Do any one have any script by which i can get a automatic email notification when a HIGH CPU usage n >80 % occurs on the Sql server 2005 instance with the query which is causing the high CPU usage.thanks

Network issue?

dwilliscp — Tue, 12 Feb 2013 08:41:51 GMT

I have a job that kicks off on (lets say) server A, and it runs two SQL statements with the FROM being a different server... lets say server B. Now the trace logs for both servers do not show any memory pressure, the only I/O wait is 4, and the CPU's never reach 60%. The job kicks off and shows up in the trace log on server A, but it is 5 min later before the SQL shows up on server B's trace log. Then it quickly runs all the sql statements, and then server A shows the completion of the job.I can not .. figure out why this nights job went from running in about 40 sec, to almost 6 min. Other than some strange network issue, can anyone give me any idea's why server B took so long to have the first query show up in it's trace?

Poor Performing SQL Server Queries

Minnu — Tue, 12 Feb 2013 02:44:04 GMT

Hi Team,Am using below query to get top 20 poor performing queries, finally i got the result set of 20 records, how to find that particular query is performing slow, what are the major things to be considered, can u please explan.SELECT TOP 20 GETDATE() AS "Collection Date", qs.execution_count AS "Execution Count", SUBSTRING(qt.text,qs.statement_start_offset/2 +1, (CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) AS "Query Text", DB_NAME(qt.dbid) AS "DB Name", qs.total_worker_time AS "Total CPU Time", qs.total_worker_time/qs.execution_count AS "Avg CPU Time (ms)", qs.total_physical_reads AS "Total Physical Reads", qs.total_physical_reads/qs.execution_count AS "Avg Physical Reads", qs.total_logical_reads AS "Total Logical Reads", qs.total_logical_reads/qs.execution_count AS "Avg Logical Reads", qs.total_logical_writes AS "Total Logical Writes", qs.total_logical_writes/qs.execution_count AS "Avg Logical Writes", qs.total_elapsed_time AS "Total Duration", qs.total_elapsed_time/qs.execution_count AS "Avg Duration (ms)", qp.query_plan AS "Plan"FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qpWHERE qs.execution_count > 50 OR qs.total_worker_time/qs.execution_count > 100 OR qs.total_physical_reads/qs.execution_count > 1000 OR qs.total_logical_reads/qs.execution_count > 1000 OR qs.total_logical_writes/qs.execution_count > 1000 OR qs.total_elapsed_time/qs.execution_count > 1000ORDER BY qs.execution_count DESC, qs.total_elapsed_time/qs.execution_count DESC, qs.total_worker_time/qs.execution_count DESC, qs.total_physical_reads/qs.execution_count DESC, qs.total_logical_reads/qs.execution_count DESC, qs.total_logical_writes/qs.execution_count DESC

Full Text Search

suresh0534 — Fri, 01 Feb 2013 13:12:58 GMT

I have one table in sql server say example Table Name: candidatesTest table contains some columnscid , cname,c_resume these are the columnscid in Int ,cname is nvarchar(50), c_resume is text Data Type.I am Storing candidates resume in c_resume text filed.I have 10000 rows in table.If i search c++ resume it will showing the result of c++ and also it showing the resume other than c++if i search c++11 also it giving the results.if i search c++1 it not showing any results(Zero Results).I have written Query like this:select * from candidates WHERE contains(c_resume_text,'C++') -It shwoing c++ and also other than c++ results.select * from candidates WHERE contains(c_resume_text,'C++11') -It showing results.select * from candidates WHERE contains(c_resume_text,'C++1') -It showing Zero results.Why the above 2 and 3rd showing different results?in c_resume_text filed there is no word c++11 , but we have c++ word.I am not understanding the above results? why ?what is happening?Please help me,How can i sove the problem,Thanks,

application users are not able to connect DB

Minto Minto(quendans) — Mon, 11 Feb 2013 04:26:02 GMT

application users are not able to connect the database.How to check if server is pining and accessibilityOf the server also normal? please suggest me some possible causes.

Execution plan

tommyh — Mon, 15 Nov 2010 00:53:09 GMT

An article by Jeff Moden ([url]http://www.sqlservercentral.com/articles/T-SQL/71511[/url]) got me really confused and instead of hijacking that thread i thought i would start a new one. I had planed on asking why not using a second group by instead of the odd order by, like[code="sql"]SELECT [Month] = DATENAME(mm,SomeDateTime), DatePart(mm, SomeDateTime), Amount = SUM(SomeAmount) FROM #MyHead WHERE SomeDateTime >= '2010' AND SomeDateTime < '2011' GROUP BY DATENAME(mm,SomeDateTime), DatePart(mm, SomeDateTime) ORDER BY DatePart(mm, SomeDateTime);[/code]It looked to me to be as effective or even better since i "lost" an extra "Compute Scalar". However when i removed the where clause (to force a bit bigger result) it showed that Jeffs was faster by something like 20%. That wasnt what i found strange. It was the execution plan. Just looking at the numbers produced i would have guessed that the second one would be faster. The CPU and I/O are identical (on the matching parts). But the first query has an extra operation. So how the heck can it be faster?Running on:Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1) PS I boosted the nr of rows in Jeffs temptable to 10 000 000./T