Database Reference
In-Depth Information
Now, let us test whether the defined global policies are working or not.
1.
From the Query Editor, open a new connection against SQL instances, which is
registered as Managed Instance on UCP, and execute the following time-intensive
TSQL statements:
create table test (
x int not null,
y char(896) not null default (''),
z char(120) not null default('')
)
go
insert test (x)
select r
from
(
selectrow_number() over (order by (select 1)) r
from master..spt_values a, master..spt_values b
) p
where r <= 4000000
go
create clustered index ix_x on test (x, y)
with fillfactor=51
go
2.
The script will simulate a data load process that will lead into a slow performance
on managed SQL instance. After a few minutes, right-click on the Managed
Instances option on Utility Explorer, which will produce the following screenshot
of managed instances:
Search WWH ::
Custom Search