Viewing 15 posts - 13,066 through 13,080 (of 49,552 total)
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 22, 2013 at 2:08 am
Besides that, there's a whole bunch of problems with that trigger...
bhanupratapsngh9 (5/21/2013)
select @Amt=AsetAmt from inserted;select @AsetId=AsetId from inserted
So...
May 22, 2013 at 1:57 am
Normal, expected, documented behaviour.
SQL uses a lot of memory. It won't give it back to the OS unless the OS come under memory pressure as it's inefficient to be constantly...
May 22, 2013 at 1:55 am
While the plan cache is a decent rough idea, it is not guaranteed to have all the queries that executed, nor accurate execution characteristics for them, as the stats are...
May 22, 2013 at 1:31 am
Not enough information.
How much TempDB space does the application that uses those databases require? That's the minimum that TempDB should be.
May 21, 2013 at 1:40 pm
Shrink alone can't speed up a query. Probably something else going on as well.
No indexes and no primary key means every single operation is going to be a table scan....
May 21, 2013 at 9:49 am
jeremy.jamieson (5/21/2013)
SQLSACT (5/21/2013)
What is among your top waits?This is the result of the query, keeping in mine this is not the peak hours of use with our systems
The waits stats...
May 21, 2013 at 9:43 am
jeremy.jamieson (5/21/2013)
May 21, 2013 at 9:42 am
jeremy.jamieson (5/21/2013)
It seems in the first step its pulling the same statistics the PAL program i used disk I/O, CPU, memory ect,
No, it's not.
PAL pulls the disk, CPU, memory statistics....
May 21, 2013 at 8:23 am
No. Show statistics doesn't touch the table
May 21, 2013 at 8:08 am
jpSQLDude (5/21/2013)
Right now my CPUs are at 100%... so what is causing this? Someone must have come up with a way to figure this out!
Query sys.dm_exec_requests and see what...
May 21, 2013 at 8:05 am
Index fragmentation is quite unlikely to cause sudden slow performance. Index fragmentation is in fact only a concern when you're doing large range scans from disk.
Now statistics, that's a lot...
May 21, 2013 at 6:30 am
shohelr2003 (5/21/2013)
Kingston Dhasian (5/21/2013)
Do you have scheduled log backups or do you monitor and take the log backups manually?I have not scheduled it but I do it manually.
Err.. why? Doesn't...
May 21, 2013 at 5:43 am
shohelr2003 (5/21/2013)
May 21, 2013 at 4:25 am
Viewing 15 posts - 13,066 through 13,080 (of 49,552 total)