Simple insert Query taking time RRS feed

  • Question

  • 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




    set nocount on

    declare @a int

    set @a=1

    while @a<=100000


    insert into test values(@a,@a)

    SET @a=@a+1



    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.





    Thursday, October 13, 2011 1:47 AM