Hi all,
Simple insert query is taking much time in one of my client UAT environment.The UAT server is configured as below.
Windows 2008 server,MS SQL server 2008,8 GB Ram,16 processor.I have executed the following query to test the time
create table dbo.test
(a int,b int)
set nocount on
declare @a int
set @a=1
while @a<=100000
begin
insert into test values(@a,@a)
SET @a=@a+1
end
The above query insert is taking around 10 min.But the same executed in my local machine its completed within 1:15 minute.What are all the areas to check the same to find the solution.
Any Server level things to be configured.
Regards
Siva