I have one reporting application which was running smoothly for last 3 years without any problem.For last 3 days I observed lots of blocker processes which brought down the performance Every maintainence activity(like re indexing,update statistics,reorganizing,shrinking etc) is working fine. There is...

Hi, We have two query plans for the same "prepared SQL statement", one runs slower and one runs faster. The on runs slower does SORT operation which takes more CPU resources and has StatementOptmEarlyAbortReason="GoodEnoughPlanFound", the other one (Good one) doesn't do any sort...

Hi I have SQL Server 2005 enterprise edition running on Xeon CPU (4 processors) with 8GB ram. Antivirus Symantec also running on the same box as SQL Server 2005 (which will be on a separate server next month). We also replicate data from JDE to SQL using 3 rd party tool (datamirror) continuously. Everything...

I have 2 sql 2000 ent. A/P nodes installed on w2k3 ent. 32 bit. each with 16 GB RAM. SQL installed on c: and databases on e: and log files on l: on SAN. What should be the optimum page file size? Should it be created on all drives to improve performance? I am facing slowness problems during peak times...

Hi There I created the test below as a quick check of the servers committed write capability. This scripts runs acceptably fast on my laptop, (which is about 3 year old 7200rpm hard disk, 2.something GHZ pentium processor. 2gb memory. Windows XP 32 bit.) By comparision we have a 64 bit server that is...

I have a webapp in Asp.net 1.1 with SqlServer 2005 Express Edition. It's a typical small website with 1.000 registered users and 100 articles (most textual) published. This thing is on a Pentium 4 single-processor machine with 512mb of RAM which hosts both the SQL and the IIS. The site has only 600...

I have the following view's select statement - I have indexes on all the columns used in the joins and wheres and still - "select *" on this view is taking 2 minutes for getting 3493 rows. I see an "INDEX SPOOL" in the query execution plan. I broke it down to multiple views and...

I am seeing these errors as well. Does that mean the error never fired if in the LAST OCCURRED column it says NEVER OCCURRED? This would be a good sign right? Company is on SQL 7 For the top msdb and tempdb erros they have an Error of 9002 Thanks

Hi, I am using SQL Server 2005 Import wizard/DTS Package to Import one table data from X Server to Y Server. To Import 20 million records its taking almost >3 hours, when i am importing i observerd in Y Server -> Task Manager -> Network Utilization is 0.25% of 1 Gbps. If i am copying any fdata...

We are currently an IBM shop; however, IBM seems to not understand basic I/O configurations with SQL Server and I am pulling my hair one piece at a time. The particular database in question is a third-party product that is so poorly designed; however, my finance department just think its peachy. I just...