I tried to go through this process of moving from 1.4.8 to 1.4.9 using the automatic script, this runs various errors and will not work, I have had this issue since I started using solidcp, the enterprise and portal are on standalone machines, ie workgroup, not in a domain, so I gave up with this.
I then tried the manual upgrade option, I overwrote the enterprise servers files, then ran the sql update script, then moved onto the portal and server, BIG MISTAKE, the control panel crashed, it firstly could not load and had an error, which came back to an assembly issue, I thought it was due to the theme option changing, when I tried to add a new theme, the table for the themes was not there, total balls up. I then decided to use the installer to upgrade the options, first did the enterprise server, and it ran through with no issues, the tables were all there, I then followed on with the portal and server this way and managed to get my portal back up and running.
However, not it seems as if the whole system is SLOW as hell, adding a domain takes about 2 minutes if not longer, it used to take seconds before, now it takes much more time. I have a sneaky feeling that there is some issues either with the DB or with the calls being made, even to get into the websites on various servers takes ages to collect the info, etc.
I noticed this with 1.4.8 where it at stages takes ages, other times it is quick, where can we look to try and identify where the issues are, we have multiple servers with more than enough resources on each, if we access the servers themselves and manually do this its instantaneous.
Looking further into this, the add domain takes about 4minutes to complete, but if I check the dns servers the master and slave, the zone is written to the servers almost immediately, but solidcp looks like its either doing some other thing in the background or expecting a response back from somewhere... Looking at the db it seems this is also written to the db instantaneously as well, so I am not sure where this 4 minute delay is coming from. Deleting the domain takes about 1 second..
Definitely an issue here, looking at a mysql trace there id definitely about a 3 and a half minute delay between creating the domain and the script continuing on, below is a trace of the process of creating a domain and adding a website. as can be seen from the start time to the end time its almnost 4 minutes. I could do this myself faster manually.
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3517</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.04+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.043+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=0 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">630</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.043+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.043+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=193 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'a8d31363073c41b39650ec471c72a0f1',@scheduleId=0,@packageId=808,@userId=1,@effectiveUserId=1,@taskName=N'ADD',@itemId=0,@itemName=N'4test.co.za',@startDate='2023-04-04 13:01:20.040',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">461</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.047+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.047+02:00</Column>
<Column id="16" name="Reads">13</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=193,@date='2023-04-04 13:01:20.040',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: 4test.co.za',@textIdent=0,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">775</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.067+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.067+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=193,@date='2023-04-04 13:01:20.057',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'DNS_ZONE_ADD',@textIdent=0,@xmlParameters=N'<parameters><parameter value="4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">638</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.07+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.07+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=194 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'7dc260f070c2468697d81a86afa60236',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'ADD',@itemId=0,@itemName=N'4test.co.za',@startDate='2023-04-04 13:01:20.057',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DNS_ZONE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">4264</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.693+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.697+02:00</Column>
<Column id="16" name="Reads">1919</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">16</Column>
<Column id="1" name="TextData">declare @p8 int set @p8=21224 exec AddServiceItem @actorId=1,@PackageID=808,@ServiceID=36,@ItemName=N'4test.co.za',@ItemTypeName=N'SolidCP.Providers.DNS.SecondaryDnsZone, SolidCP.Providers.Base',@xmlProperties=N'<properties />',@CreatedDate='2023-04-04 13:01:20.697',@ItemID=@p8 output select @p8</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3426</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.7+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.703+02:00</Column>
<Column id="16" name="Reads">1907</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p8 int set @p8=21225 exec AddServiceItem @actorId=1,@PackageID=808,@ServiceID=28,@ItemName=N'4test.co.za',@ItemTypeName=N'SolidCP.Providers.DNS.DnsZone, SolidCP.Providers.Base',@xmlProperties=N'<properties />',@CreatedDate='2023-04-04 13:01:20.713',@ItemID=@p8 output select @p8</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">510</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.703+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.703+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec UpdateBackgroundTask @Guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=193,@scheduleId=0,@packageId=808,@taskName=N'ADD',@itemId=21225,@itemName=N'4test.co.za',@finishDate=NULL,@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">563</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.707+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.707+02:00</Column>
<Column id="16" name="Reads">21</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=6146 exec AddDomain @DomainID=@p1 output,@ActorId=1,@PackageId=808,@ZoneItemId=21225,@DomainName=N'4test.co.za',@HostingAllowed=0,@WebSiteId=0,@MailDomainId=0,@IsSubDomain=0,@IsPreviewDomain=0,@IsDomainPointer=0 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">427</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.71+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.71+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec UpdateBackgroundTask @Guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=193,@scheduleId=0,@packageId=808,@taskName=N'ADD',@itemId=6146,@itemName=N'4test.co.za',@finishDate=NULL,@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">710</Column>
<Column id="14" name="StartTime">2023-04-04T13:01:20.713+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:01:20.713+02:00</Column>
<Column id="16" name="Reads">7</Column>
<Column id="17" name="Writes">1</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddAuditLogRecord @recordId=N'a8d31363073c41b39650ec471c72a0f1',@severityId=0,@UserID=1,@username=N'xxxxxxxxx',@PackageID=808,@ItemId=6146,@itemName=N'4test.co.za',@startDate='2023-04-04 13:01:20.040',@finishDate='2023-04-04 13:01:20.713',@sourceName=N'DOMAIN',@taskName=N'ADD',@executionLog=N'<log><parameters /><records><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Domain Name: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Create Dns Zone: True</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Is Sub Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Is Preview Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Is Domain Pointer: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>Allow Sub Domains: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:01:20" ident="0"><text>DNS_ZONE_ADD</text><textParameters><value>4test.co.za</value></textParameters><stackTrace /></record></records></log>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">20982</Column>
<Column id="14" name="StartTime">2023-04-04T13:04:56.173+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:04:56.193+02:00</Column>
<Column id="16" name="Reads">470</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">16</Column>
<Column id="1" name="TextData">exec GetServiceItemByName @actorId=1,@packageId=808,@itemName=N'4test.co.za',@itemTypeName=N'SolidCP.Providers.Web.WebSite, SolidCP.Providers.Base',@groupName=NULL</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3512</Column>
<Column id="14" name="StartTime">2023-04-04T13:04:56.197+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:04:56.2+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">610</Column>
<Column id="14" name="StartTime">2023-04-04T13:04:56.2+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:04:56.2+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=195 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'19d9f6e2c31445e8908805dd1ee5a840',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'ADD',@itemId=0,@itemName=N'4test.co.za',@startDate='2023-04-04 13:04:56.190',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'WEB_SITE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<?xml version="1.0" encoding="utf-16"?>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3596</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:11.74+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:11.743+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3844</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:11.747+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:11.75+02:00</Column>
<Column id="16" name="Reads">134</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">16</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'www.4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">6799</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.61+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.617+02:00</Column>
<Column id="16" name="Reads">1987</Column>
<Column id="17" name="Writes">6</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p8 int set @p8=21226 exec AddServiceItem @actorId=1,@PackageID=808,@ServiceID=145,@ItemName=N'4test.co.za',@ItemTypeName=N'SolidCP.Providers.Web.WebSite, SolidCP.Providers.Base',@xmlProperties=N'<properties><property name="SiteId" value="4test.co.za" /><property name="WebDeploySitePublishingProfile" value="" /><property name="WebDeployPublishingAccount" value="" /><property name="SiteIPAddressId" value="307" /><property name="WebDeployPublishingPassword" value="" /><property name="DataPath" value="c:\domains\HostworXWebs\4test.co.za\backups" /><property name="FrontPagePassword" value="" /><property name="LogsPath" value="c:\domains\HostworXWebs\4test.co.za\logs" /><property name="FrontPageAccount" value="" /><property name="WebDeploySitePublishingEnabled" value="False" /></properties>',@CreatedDate='2023-04-04 13:05:15.610',@ItemID=@p8 output select @p8</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">426</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.633+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.633+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:15.627',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: 4test.co.za',@textIdent=0,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3327</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.633+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.637+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">455</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.64+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.64+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:15.640',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'WEB_SITE_ADD_POINTER',@textIdent=0,@xmlParameters=N'<parameters><parameter value="4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">432</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.64+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.64+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=196 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'1d736b5430f54c6ab117b65d402802dc',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'ADD_POINTER',@itemId=21226,@itemName=N'4test.co.za',@startDate='2023-04-04 13:05:15.627',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'WEB_SITE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">438</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.643+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.643+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:15.640',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain pointer: 4test.co.za',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3297</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.647+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.65+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3818</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:15.65+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:15.653+02:00</Column>
<Column id="16" name="Reads">134</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'www.4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">691</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.127',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Add Binding: 4test.co.za 196.22.190.52 80',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">432</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.127',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Add Binding: www.4test.co.za 196.22.190.52 80',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">1530</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.13+02:00</Column>
<Column id="16" name="Reads">75</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec GetDomainByName @ActorId=1,@domainName=N'4test.co.za',@SearchOnDomainPointer=0,@IsDomainPointer=0</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3696</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.133+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.137+02:00</Column>
<Column id="16" name="Reads">132</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">15</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">480</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.14+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.14+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.140',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'DOMAIN_ADD',@textIdent=1,@xmlParameters=N'<parameters><parameter value="4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">405</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.14+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.14+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=197 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'6753153b53d34b3482ba6c1d59cf7028',@scheduleId=0,@packageId=808,@userId=1,@effectiveUserId=1,@taskName=N'ADD',@itemId=0,@itemName=N'4test.co.za',@startDate='2023-04-04 13:05:16.140',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">406</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.143+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.143+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.140',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: 4test.co.za',@textIdent=2,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">517</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.15+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.15+02:00</Column>
<Column id="16" name="Reads">19</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=6147 exec AddDomain @DomainID=@p1 output,@ActorId=1,@PackageId=808,@ZoneItemId=0,@DomainName=N'4test.co.za',@HostingAllowed=0,@WebSiteId=0,@MailDomainId=0,@IsSubDomain=0,@IsPreviewDomain=0,@IsDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">387</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.153+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.153+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec UpdateBackgroundTask @Guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=195,@scheduleId=0,@packageId=0,@taskName=N'ADD',@itemId=6147,@itemName=N'4test.co.za',@finishDate=NULL,@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'WEB_SITE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">404</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.16+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.16+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.157',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: 4test.co.za',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">418</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.167+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.167+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.173',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: 4test.co.za',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">415</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.17+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.17+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.173',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'DOMAIN_UPDATE',@textIdent=1,@xmlParameters=N'<parameters><parameter value="4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">393</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.17+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.17+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=198 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'26ade699da994407a5e58f0509d0ad87',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'UPDATE',@itemId=6147,@itemName=N'4test.co.za',@startDate='2023-04-04 13:05:16.173',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">1025</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.173+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.173+02:00</Column>
<Column id="16" name="Reads">65</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec GetDomainByName @ActorId=1,@domainName=N'www.4test.co.za',@SearchOnDomainPointer=0,@IsDomainPointer=0</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">3921</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.173+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.177+02:00</Column>
<Column id="16" name="Reads">134</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=0 exec CheckDomain @Result=@p1 output,@packageId=808,@domainName=N'www.4test.co.za',@isDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">428</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.18+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.18+02:00</Column>
<Column id="16" name="Reads">10</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.173',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'DOMAIN_ADD',@textIdent=1,@xmlParameters=N'<parameters><parameter value="www.4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">386</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.18+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.18+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=199 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'7c54b91bf1b349a0bcb1792bac3ecc04',@scheduleId=0,@packageId=808,@userId=1,@effectiveUserId=1,@taskName=N'ADD',@itemId=0,@itemName=N'www.4test.co.za',@startDate='2023-04-04 13:05:16.173',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">399</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.183+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.183+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.173',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: www.4test.co.za',@textIdent=2,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">511</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.19+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.19+02:00</Column>
<Column id="16" name="Reads">19</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=6148 exec AddDomain @DomainID=@p1 output,@ActorId=1,@PackageId=808,@ZoneItemId=0,@DomainName=N'www.4test.co.za',@HostingAllowed=0,@WebSiteId=0,@MailDomainId=0,@IsSubDomain=0,@IsPreviewDomain=0,@IsDomainPointer=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">377</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.19+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.19+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec UpdateBackgroundTask @Guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=195,@scheduleId=0,@packageId=0,@taskName=N'ADD',@itemId=6148,@itemName=N'4test.co.za',@finishDate=NULL,@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'WEB_SITE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">414</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.203+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.203+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.203',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: www.4test.co.za',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">403</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="16" name="Reads">8</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.203',@exceptionStackTrace=NULL,@innerTaskStart=0,@severity=0,@text=N'Domain Name: www.4test.co.za',@textIdent=1,@xmlParameters=N'<parameters />'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">436</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">15</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.203',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'DOMAIN_UPDATE',@textIdent=1,@xmlParameters=N'<parameters><parameter value="www.4test.co.za" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">403</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.213+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=200 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'c7a0a212970842389680037920728b6b',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'UPDATE',@itemId=6148,@itemName=N'www.4test.co.za',@startDate='2023-04-04 13:05:16.203',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'DOMAIN',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">713</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.61+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.61+02:00</Column>
<Column id="16" name="Reads">10</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.610',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'FILES_CREATE_FILE',@textIdent=0,@xmlParameters=N'<parameters><parameter value="\4test.co.za\wwwroot\holding.aspx" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">503</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.61+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.61+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=201 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'f2f6bc6b62e54d74819fadfd24a9705b',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'CREATE_FILE',@itemId=808,@itemName=N'\4test.co.za\wwwroot\holding.aspx',@startDate='2023-04-04 13:05:16.610',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'FILES',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">526</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.65+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.65+02:00</Column>
<Column id="16" name="Reads">9</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec AddBackgroundTaskLog @taskId=195,@date='2023-04-04 13:05:16.640',@exceptionStackTrace=NULL,@innerTaskStart=1,@severity=0,@text=N'FILES_UPDATE_BINARY_CONTENT',@textIdent=0,@xmlParameters=N'<parameters><parameter value="\4test.co.za\wwwroot\holding.aspx" /></parameters>'</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">53</Column>
<Column id="13" name="Duration">429</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.65+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.65+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">declare @p1 int set @p1=202 exec AddBackgroundTask @BackgroundTaskID=@p1 output,@guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=N'7b032425fe7e4a70a027323e9f3bf18f',@scheduleId=0,@packageId=0,@userId=1,@effectiveUserId=1,@taskName=N'UPDATE_BINARY_CONTENT',@itemId=808,@itemName=N'\4test.co.za\wwwroot\holding.aspx',@startDate='2023-04-04 13:05:16.640',@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'FILES',@severity=0,@completed=0,@notifyOnComplete=0,@status=1 select @p1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">62</Column>
<Column id="13" name="Duration">682</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.783+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.783+02:00</Column>
<Column id="16" name="Reads">2</Column>
<Column id="17" name="Writes">0</Column>
<Column id="18" name="CPU">0</Column>
<Column id="1" name="TextData">exec UpdateBackgroundTask @Guid='CB069E8D-4E72-4415-A577-29E759048F12',@taskId=195,@scheduleId=0,@packageId=0,@taskName=N'ADD',@itemId=21226,@itemName=N'4test.co.za',@finishDate=NULL,@indicatorCurrent=0,@indicatorMaximum=0,@maximumExecutionTime=-1,@source=N'WEB_SITE',@severity=0,@completed=0,@notifyOnComplete=0,@status=1</Column>
</Event>
<Event id="10" name="RPC:Completed">
<Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
<Column id="9" name="ClientProcessID">8340</Column>
<Column id="11" name="LoginName">xxxxxxxxx</Column>
<Column id="12" name="SPID">62</Column>
<Column id="13" name="Duration">559</Column>
<Column id="14" name="StartTime">2023-04-04T13:05:16.793+02:00</Column>
<Column id="15" name="EndTime">2023-04-04T13:05:16.793+02:00</Column>
<Column id="16" name="Reads">11</Column>
<Column id="17" name="Writes">2</ColumnColumn>0</ColumnColumn>exec AddAuditLogRecord @recordId=N'19d9f6e2c31445e8908805dd1ee5a840',@severityId=0,@UserID=1,@username=N'xxxxxxxxx',@PackageID=0,@ItemId=21226,@itemName=N'4test.co.za',@startDate='2023-04-04 13:04:56.190',@finishDate='2023-04-04 13:05:16.780',@sourceName=N'WEB_SITE',@taskName=N'ADD',@executionLog=N'<log><parameters /><records><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>Domain ID: 6146</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>Domain Name: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>WEB_SITE_ADD_POINTER</text><textParameters><value>4test.co.za</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>Domain pointer: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>Host name: </text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:15" ident="0"><text>updateWebSite: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Add Binding: 4test.co.za 196.22.190.52 80</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Add Binding: www.4test.co.za 196.22.190.52 80</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>DOMAIN_ADD</text><textParameters><value>4test.co.za</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Create Dns Zone: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Sub Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Preview Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Domain Pointer: True</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Allow Sub Domains: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain ID: 6147</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain ID: 6147</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: 4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>DOMAIN_UPDATE</text><textParameters><value>4test.co.za</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>DOMAIN_ADD</text><textParameters><value>www.4test.co.za</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: www.4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Create Dns Zone: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Sub Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Preview Domain: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Is Domain Pointer: True</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Allow Sub Domains: False</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain ID: 6148</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: www.4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain ID: 6148</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>Domain Name: www.4test.co.za</text><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>DOMAIN_UPDATE</text><textParameters><value>www.4test.co.za</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>FILES_CREATE_FILE</text><textParameters><value>\4test.co.za\wwwroot\holding.aspx</value></textParameters><stackTrace /></record><record severity="0" date="04/04/2023 13:05:16" ident="0"><text>FILES_UPDATE_BINARY_CONTENT</text><textParameters><value>\4test.co.za\wwwroot\holding.aspx</value></textParameters><stackTrace /></record></records></log>'</Column/Event>
>
ok so, I have checked all the sw on all the servers and the sw is all 100% ok, so I decided to start looking elsewhere. What I can now confirm, is the following:
If I add a .com, .co, .xyz, ,dev domain to the cp it adds it in about 20 seconds... if I add a .co.za domain, it takes 4 minutes to add, so it seems that its related to a lookup or something.
