Viewing 15 posts - 24,616 through 24,630 (of 49,552 total)
malachyrafferty (7/28/2011)
any bug fixs that could improve overall performance?
For SQL, no. For you own code, it's called tell at the developers to fix their mess.
Bad query performance is seldom 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
July 28, 2011 at 10:01 am
Bug fixes (including some nasties). It's generally frowned on for a service pack to include new features. MS took a lot of flack for that with 2005 SP2.
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 28, 2011 at 9:49 am
I would recommend that you don't use /3GB here, all that will let SQL do is access 3GB of memory instead of 2. The memory above the 4GB boundry will...
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 28, 2011 at 7:54 am
ajsnyman (7/28/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 28, 2011 at 7:53 am
ajsnyman (7/28/2011)
Ninja's_RGR'us (7/28/2011)
ajsnyman (7/28/2011)
GilaMonster (7/28/2011)
ajsnyman (7/28/2011)
I like that the 2nd DB can be used as a reporting server 🙂If you do that, the second server must be licensed.
Cool, thanks 🙂
Not...
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 28, 2011 at 7:30 am
ananda.murugesan (7/28/2011)
Running - a query which is being executed on a CPU is called a running query. This query is responsible for CPU time.
Runnable – a query...
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 28, 2011 at 7:28 am
ananda.murugesan (7/28/2011)
GilaMonster (7/28/2011)
You should never just kill something unless you know what impact is will have. What if it's something critically important.
Check...
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 28, 2011 at 7:26 am
ajsnyman (7/28/2011)
I like that the 2nd DB can be used as a reporting server 🙂
If you do that, the second server must be licensed.
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 28, 2011 at 6:55 am
They're waiting for locks. Hence you have some blocking.
You should never just kill something unless you know what impact is will have. What if it's something critically important.
Check what they're...
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 28, 2011 at 6:51 am
Check what they're waiting for. The wait_type 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
July 28, 2011 at 6:26 am
32 bit or 64 bit? (OS and 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 28, 2011 at 6:25 am
In a deadlock, SQL's deadlock detector will pick one of the participants and roll it back automatically.
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 28, 2011 at 5:56 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
July 28, 2011 at 5:54 am
Brandie Tarvin (7/28/2011)
So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.
I have hot cross buns. And I'm not sharing.
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 28, 2011 at 4:59 am
Read up on SQL audit.
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 28, 2011 at 4:53 am
Viewing 15 posts - 24,616 through 24,630 (of 49,552 total)