Viewing 15 posts - 26,536 through 26,550 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1097733-391-1.aspx
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
April 25, 2011 at 3:03 am
nirav.gandhi 50053 (4/24/2011)
Now Give Suggestion can i break database in multiple file groups...doing Creating multiple filie and filegroups is it possible to optimize our database..?
That's only going to help...
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
April 25, 2011 at 3:03 am
Syed Jahanzaib Bin hassan (4/24/2011)
Default value is 0 when sql server start
Yes, and if you would read the article you referenced and I quoted from..
The default value for max worker...
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
April 25, 2011 at 2:55 am
Can you post the plans please, not pictures of them. Right-click, save as .sqlplan, zip, attach to your post.
While QueryA is running, can you check what it's current wait type...
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
April 25, 2011 at 2:47 am
What do the execution plans look like?
Is it a consistent difference? Run both 5 times, discard the first, average the remaining durations.
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
April 24, 2011 at 3:23 pm
If by snapshot you mean a database snapshot, then sure. Exactly as you would do for a table in any database, script the definition, copy the data, script and apply...
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
April 24, 2011 at 2:07 pm
Please note: 3 year old thread.
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
April 24, 2011 at 12:00 pm
Errr, can you be more specific please?
If you're talking about the xml form of the query execution plan, you can use XQuery on it
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
April 24, 2011 at 11:30 am
That said, one glaring misconfiguration is a 32-bit OS and no AWE. That means SQL has at most 2GB of memory, for a DB nearly 2 TB in size. 8GB...
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
April 24, 2011 at 8:56 am
That's a big area...
If it's critical and you have no idea where to start, consider getting someone in to help. It'll be far more effective in the long run.
Otherwise, this...
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
April 24, 2011 at 8:52 am
Syed Jahanzaib Bin hassan (4/24/2011)
Default for the Operating System but SQL server didnt set this as default you have to set this parameter as well
Windows Operating system doesn't have a...
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
April 24, 2011 at 4:31 am
Syed Jahanzaib Bin hassan (4/24/2011)
Index 1
Log 1
MSSQL (SQL Server binaries at the time of installation)
Best practices
Data 1 (foir base tables)
Data 2 (for transaction tables
Index 1 (for base tables indexes)
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
April 24, 2011 at 4:10 am
pluck9909 (4/23/2011)
When a user perform a transaction on a table A,can other user access table A?
Depends what is done in the transaction and what locks are taken.
If can then 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
April 23, 2011 at 2:17 pm
Craig Farrell (4/23/2011)
Phil Nicholas (4/23/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
April 23, 2011 at 2:05 pm
LutzM (4/23/2011)
GilaMonster (4/23/2011)
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement with...
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
April 23, 2011 at 2:02 pm
Viewing 15 posts - 26,536 through 26,550 (of 49,552 total)