I have a total amount of RAM used by SQL server (13GB). Is there any way to get the amount of RAM used by each application within SQL server?

Hi All, I am able to see that Clustered Index Update is taking huge % in query exec plan. Its taking around 81% in the whole query cost. Update tab t Set Status = 20 From tab t Where T . Status <> 20 And Exists( Select OL . OI From OL Where T . Id = OL . OI ) And Not Exists ( Select OL . OI From...

Hi Hassan, There is a maintenance sheduled for our database which is run daily and the steps are as :- 1) Merge Partition 2) Set Next Partititon 3). Split Partition 4). Reindex 5) Backup Log 6). Shrink DB As you wrote that Shrinking shouldn't be done after Reindexing...what I ned to cange in the...

Thanks for your reply Satya. Currently we do not have any data warehouse and also we have all applications/servrices running on a single server (Intel® Xeon® 5140 CPU 2.33 GHz and 4 GB RAM). We are planning to keep purely SQL on a new server and reporting services on the existing server. Could you please...

Hi All, Our client has an order placing system which is used by customer services to place an order. Client is reporting that the application (developed in vb6) is taking long time to add an order. In SQL point of view, many procedures are called when an order is placed. Around 10-15 stored procedures...

Hi All, I am getting warning "No join predicate" in the below function: -------------------------------------------------------------------------------------------- ALTER Function hello.Test ( @Customer VarChar(20) = Null ,@Item VarChar(20) = Null ,@UC VarChar(10) = Null ,@EF VarChar(10) =...

HI, My SQL server 2000 sp4 and windows 2003 enterprice data is stored on D drive .And the drive is coming from the SAN DS 4300 with raid 1 with 8 disk (15000 RPM ) of 68 GB.So the drive d comes to 271 GB. The issue is some times in current activity the some wait type s like LATCH_x ,PAGEIOLATCH_x occur...

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...

I have frequently seen 300 sec. as the threshold value for PLE, beyond which you should be concerned about memory pressure. Where does this value of 300 sec come from? Why wouldn't 60 sec or 1 minute be a reasonable length of time for pages to remain in memory? Thanks!