Viewing 15 posts - 14,581 through 14,595 (of 49,552 total)
Grow that log file to something sensible, and make sure that the autogrow settings aren't the default.
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
January 29, 2013 at 1:51 am
If you want all queries to only use one processor, why not pull the other 23 out? That's essentially what you've done by setting maxdop to 1. It is 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
January 29, 2013 at 1:45 am
Yes, it is a bad practice. What are you gaining by shrinking the log each week? You know it's just going to grow back, so it's not as if you...
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
January 29, 2013 at 1:38 am
Most likely the active portion of the log is at the end of the file.
Try a few 'fake' operations (create a table, populate it and then drop it) interspaced...
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
January 29, 2013 at 1:36 am
naga.rohitkumar (1/29/2013)
try this codeEXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER
That is absolute last resort...
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
January 29, 2013 at 1:35 am
Can you run CheckDB on the 2005 database?
Do you have a backup from before the DB was upgraded to SQL 2008?
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
January 29, 2013 at 1:33 am
sqlnaive (1/29/2013)
Don't you think once the statistics are upgraded, even if the new query plan is created, it will be optimal ?
Maybe, maybe not. If all 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
January 29, 2013 at 1:28 am
sqldba_newbie (1/28/2013)
Thanks. If they are in parallel shouldn't atleast 24 of them be running?
At most 24 will be running at any one time (that's how many cores you have).
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
January 29, 2013 at 1:26 am
sqldba_newbie (1/28/2013)
GilaMonster (1/28/2013)
Each operator in the parallel portion of the query plan can parallel up to maxdop/number of cores. They won't all be running, but they can all exist.
I see...
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
January 28, 2013 at 3:53 pm
Each operator in the parallel portion of the query plan can parallel up to maxdop/number of cores. They won't all be running, but they can all exist.
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
January 28, 2013 at 3:34 pm
No idea. That's not a standard procedure, must be something that your devs wrote. Check the proc, see if there are any comments and ask your colleagues
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
January 28, 2013 at 8:40 am
Check this out, see if it's applicable.
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
January 28, 2013 at 7:51 am
Then between the web server and the user app, they're sending enough stuff to SQL to run the CPU up to 100%.
Check out that book chapter I recommended. It's all...
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
January 28, 2013 at 7:44 am
Sorry, but that falls into the 10ft bargepole category for me.
Without the precise error it's a pain. Maybe he's running out of disk space, maybe something is cancelling the job/connection
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
January 28, 2013 at 6:24 am
I've been running 64 bit on my home machine for over 5 years now. Some software is installed 64 bit, most as 32 bit. Minimal problems, most were VPN clients...
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
January 28, 2013 at 6:22 am
Viewing 15 posts - 14,581 through 14,595 (of 49,552 total)