Sign in
Microsoft.com
 
Microsoft
 
 
 

none
Simple insert Query taking time RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    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
    |