Viewing 15 posts - 24,661 through 24,675 (of 49,552 total)
@SQLFRNDZ (7/26/2011)
Check any query hints you can include to improve performance depends type of query.(Nolock), (Maxdop), with recompile if it is stored procedure.
Nolock if you don't mind potentially incorrect, duplicate...
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
July 26, 2011 at 2:49 pm
opc.three (7/26/2011)
SELECT DISTINCT
collation
FROM syscolumns
WHERE id = OBJECT_ID('SALES')
...
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
July 26, 2011 at 2:49 pm
Ninja's_RGR'us (7/26/2011)
Stefan Krzywicki (7/26/2011)
Chad Crawford (7/26/2011)
Ninja's_RGR'us (7/26/2011)
Chad Crawford (7/26/2011)
Grant Fritchey (7/26/2011)
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
July 26, 2011 at 2:47 pm
Ninja's_RGR'us (7/26/2011)
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
July 26, 2011 at 2:46 pm
Run DBCC UPDATEUSAGE
Shouldn't be necessary on SQL 2005 SP3+
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
July 26, 2011 at 1:45 pm
Ninja's_RGR'us (7/26/2011)
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
July 26, 2011 at 1:44 pm
Sqlsavy (7/26/2011)
But I'm still not able to understand how these errors are generated and what is wrong with the data on SQL 2005?
It's metadata errors, there's problems with the...
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
July 26, 2011 at 1:43 pm
How are you getting the size from SQL?
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
July 26, 2011 at 12:36 pm
On the compiles and recompiles...
These counters will show high values at server start up as every incoming query needs to be compiled. The plan cache sits in memory, so 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
July 26, 2011 at 12:26 pm
This piece is just wrong.
If % Disk Time is consistently over 85%, the disk system is stressed. Avg. Disk Queue Length and Current Disk Queue Length refer to the number...
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
July 26, 2011 at 12:21 pm
Lowell, to be completely accurate you should sum that grouped by object_id, index_id. If the table is partitioned, there will be multiple rows in there for a single 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
July 26, 2011 at 11:45 am
anand_vanam (7/26/2011)
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
July 26, 2011 at 11:37 am
New as in 6 years old, yes. Introduced with SQL 2005.
Doesn't change that there's lots of info in Books Online.
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
July 26, 2011 at 11:30 am
I would think so, probably.
If sessionkey is unique, make it a unique index.
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
July 26, 2011 at 11:03 am
I would definitely recommend an index on session key. Without that, SQL's having to scan the table to find the rows for update.
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
July 26, 2011 at 10:56 am
Viewing 15 posts - 24,661 through 24,675 (of 49,552 total)