InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:10:51 GMT20http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxboth instances match the recordsVersion : sql server 2000 sp 2Wed, 25 Feb 2009 07:20:12 GMTaravind-305595http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxWhat's the number of rows that match the criteria ?Is that number the same for both instances ?How about concurrency ?What software level are you on (@@version) ?Wed, 25 Feb 2009 06:45:46 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxprimary key is there. so it has created clustered index. Rebuild doesnt give any improvement.Wed, 25 Feb 2009 06:38:09 GMTaravind-305595http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx- Is there a clustering index on that table ? if not, provide one, unless you can prove it hurts performance. Data pages may be scattered all over the place. if you have a clustering index, rebuild it. and check again after.Wed, 25 Feb 2009 05:47:33 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxThe actual table has an id, name and its description. id is the primary key.The description is huge which has length ranging from 3000 to 5000 characters.I use simply query to get all the content from the table which has description not null. The query takes in 3-4 mins to get that resultset. Because of which the user has to wait for that time in the front end. The requriement is to reduce the wait time.Wed, 25 Feb 2009 05:28:27 GMTaravind-305595http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxGet things organized ![i]create table Testperf (col1 varchar(5000) )[/i]cannot be a reference because of ... table design.No indexes, a table with a single column, ...If you want to stress test io try SQLIOSim tool (download from MS)After you migrated the db to prod, did you perform db maintenance ?- rebuild indexes- refresh statistics What performance issues are you getting ?- timeouts- deadlocks- ...Wed, 25 Feb 2009 02:53:21 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxIndependent on the environment, can we make this query run faster by anyway ??Our ultimate aim is to run the query faster. Is the performance lack due to the huge data size in that column ?? Can we overcome that ?Wed, 25 Feb 2009 02:01:56 GMTaravind-305595http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxThe same case is with the QA environment also ? which wont have difference in load when compared with development.Wed, 25 Feb 2009 01:49:53 GMTaravind-305595http://www.sqlservercentral.com/Forums/Topic664033-65-1.aspx[quote][b]aravind (2/24/2009)[/b][hr]Normally any company will have production server highly configured than the development server. So in that case how this could happen?"Production server slower than development server".[/quote]More users and hence more load on production. More data on production. Older statistics. More fragmented indexes. Different exec plan.Lots of reasonsWed, 25 Feb 2009 00:19:21 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic664033-65-1.aspxHi,I have a select query from a table which has a column with huge data. The select query takes 14 secs in the development server but the same query takes 70 secs in the production server.To simulate the issue, I created the following script and tested in both the environmentscreate table Testperf(col1 varchar(5000) )declare @i intselect @i = 1while @i <= 1000begininsert into Testperfselect replicate('Bravo',600)set @i = @i + 1endselect * from TestperfNormally any company will have production server highly configured than the development server. So in that case how this could happen?"Production server slower than development server".Tue, 24 Feb 2009 23:54:16 GMTaravind-305595