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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 9:43 am
jeremy.jamieson (5/21/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 8:23 am
No. Show statistics doesn't touch the table
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 8:05 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 7:36 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 5:43 am
shohelr2003 (5/21/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 21, 2013 at 4:25 am
Viewing 15 posts - 13,066 through 13,080 (of 49,552 total)