Viewing 15 posts - 36,286 through 36,300 (of 49,562 total)
Or you can take a substring.
Look up LEFT and SUBSTRING in SQL's books online.
October 15, 2009 at 3:53 pm
Elliott W (10/15/2009)
October 15, 2009 at 3:48 pm
Fraggle-805517 (10/15/2009)
Any thoughts on how to go about figuring out what is causing those?
Sub-optimal queries
Poor row estimates by the optimiser.
Use sys.dm_exec_requests to look for queries prone to CXPacket waits...
October 15, 2009 at 3:40 pm
Fraggle-805517 (10/15/2009)
The ol' magic 8 ball.
So 8 processor cores? No hyperthreading?
7,086,376.171/8 = 885422.02 -- wait time is cumulative over all processors, so divide by 8 to get actual time....
October 15, 2009 at 3:32 pm
Bill Mosca (10/15/2009)
I guess you can't backup a log without having at least one full backup.
No you can't. Until a full backup is taken, the log is auto-truncated on checkpoint...
October 15, 2009 at 3:16 pm
jordon.shaw (10/15/2009)
October 15, 2009 at 3:06 pm
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.
Can you find/get vendor to find the wait type...
October 15, 2009 at 2:55 pm
chk2009 (10/15/2009)
Thanks for your reply, yes I want to reduce cpu usage, I believe SQL server is taking more memory.
Find the queries that are using all the CPU. Optimise them....
October 15, 2009 at 10:05 am
SQL 2005 or SQL 2000?
Check the maint plan history, check the SQL error logs.
October 15, 2009 at 9:53 am
What exactly are you looking for? Advice on reducing the cpu usage?
Are you sure it's SQL using all the CPU time?
October 15, 2009 at 9:45 am
Slick84 (10/15/2009)
Okay Gail, here is my execution plan after making the above changes. Unique non-clustered index on fstrShortsku and EDPno included in index for tblRegularItems.
Excellent. This looks about as good...
October 15, 2009 at 9:41 am
Steve Vassallo (10/15/2009)
What about SQL 2008? Is this an option there?
Yes.
SQL 2008 SP1 CU2 allows locked pages on standard edition. Good reference for this topic is the...
October 15, 2009 at 9:37 am
Slick84 (10/15/2009)
Also, is it possible for me to "alter" my non clustered index on tblregularitems and add the 'Include' clause in there?
Drop Index
Create Index
October 15, 2009 at 8:18 am
Viewing 15 posts - 36,286 through 36,300 (of 49,562 total)