Simple insert Query taking time

• Question

• 

  

  0

  Sign in to vote

  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

  Thursday, October 13, 2011 1:47 AM