Viewing 15 posts - 30,301 through 30,315 (of 49,552 total)
adrianchamp (9/29/2010)
....
If this low memory for sqlservr.exe (in task manager) is a consequence of using the trace flag then...
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
September 29, 2010 at 6:59 am
Right now I'm feeling the pain of project managers rather than BAs
Got a project manager that holds a weekly meeting in which does the following:
* Asks the developers what they...
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
September 29, 2010 at 6:53 am
abcim (9/29/2010)
Not sure I understand your question.
I mean if I am using a column just for Joining to another table, It is worth to create an Index for this column.
Maybe....
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
September 29, 2010 at 6:02 am
abcim (9/29/2010)
Is we create an Index for columns used for joining?
Not sure I understand your question.
two filtering predicates (column = constant) are first in the index with the join column...
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
September 29, 2010 at 5:33 am
How are you seeing that memory usage?
Using AWE or is locked pages enabled?
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
September 29, 2010 at 5:30 am
That 'no permission or not exists' refers to the table 'dbo.NetFlowDetail_449_1428585', not to an index. Hence you need to query sys.tables in each database (or write code that loops through...
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
September 29, 2010 at 4:49 am
I suspect the info will be in the SQL error log.
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
September 29, 2010 at 4:45 am
CirquedeSQLeil (9/29/2010)
Things seem to have slowed down a bit on the forums - or is it just perception?
Agreed. Certainly fewer posts that I can answer.
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
September 29, 2010 at 4:41 am
abcim (9/29/2010)
Is the column at left most must be the first Column in Index? Here first column is colA1.
No. Order of predicates in the where clause is irrelevant. You can...
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
September 29, 2010 at 4:41 am
Without further information, I'd probably put (ColA2, ColA3, ColA1) to ensure that the index will be used for the filters even if it's not feasible for the join (depending on...
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
September 29, 2010 at 4:20 am
arr.nagaraj (9/29/2010)
Default trace contains the recently ran queries along with a few useful informationlike CPU, starttime etc. .. Probably can help your root cause analysis
The default trace does not contain...
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
September 29, 2010 at 4:16 am
That query is dependent on the queries' plans still being in cache, which means no restarts of the SQL process.
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
September 29, 2010 at 3:49 am
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
September 29, 2010 at 3:46 am
What's the definition of the table CLH_ERROSRETORNO? (Post the CREATE TABLE statement)
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
September 29, 2010 at 2:37 am
Sysadmin has complete and total control over the entire instance, has all permissions to do anything and is not affected by DENY.
I suggest you have a read through 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
September 29, 2010 at 2:03 am
Viewing 15 posts - 30,301 through 30,315 (of 49,552 total)