Viewing 15 posts - 22,081 through 22,095 (of 49,552 total)
At only 9% free I wouldn't waste time shrinking. Little gain for lots of cost.
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
November 21, 2011 at 12:16 am
Please, please don't shrink your database. It sounds like you're not properly managing your logs.
Please read through this - Managing Transaction Logs[/url]
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
November 21, 2011 at 12:14 am
What's the definition of PURCHASE_ORDER? Does it also have a foreign key to Merchandise?
If so, that's the problem as it means there are two paths from Purchase_Order_Line to Merchandise -...
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
November 21, 2011 at 12:12 am
Please read this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
November 20, 2011 at 2:13 pm
Yuri55 (11/20/2011)
Gail,Thanks for your response- I run DBCC CHECKDB with no_infomsgs 2 times but both times failed after 8 min execution time ("Internal error- contact sys admin"- something like this)-
"something...
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
November 20, 2011 at 2:11 pm
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Post the full and complete results here.
Don't run physical_only, not enough is done.
Let's run that first, see what it says and how bad 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
November 20, 2011 at 1:25 pm
From exec_query_stats you can't. That DMV shows an aggregated summary of query statistics.
From sys.dm_exec_sessions, they're columns in that DMV.
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
November 20, 2011 at 11:30 am
goofy2sql (11/20/2011)
To be honest not sure; its only that the processes running are all sleeping processes and are in MSDB, Master; and they use a lot of CPU. How 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
November 20, 2011 at 9:04 am
The very first question is, is there a problem?
Very few of those counters have specific values that say for certain that there is a problem, it's deviation from normal that's...
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
November 20, 2011 at 7:36 am
Lexa (11/19/2011)
GilaMonster (11/19/2011)
Is it consistently slow or slow at random times? Slow for specific parameter values and fast for others or slow for all?
Random times. I caputred a trace...
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
November 20, 2011 at 7:14 am
Actually, looking at this again, all you need to do is change this:
$order = " ORDER BY user_id DESC LIMIT 1";
to this
$order = " ORDER BY logindate DESC LIMIT 1";
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
November 20, 2011 at 7:11 am
EXEC sp_spaceused
That'll give you an idea how much free space there is in the DB. If there's more than 10-20% free, consider a once-off shrink. You'll probably need to do...
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
November 20, 2011 at 5:36 am
spaceinvaders (11/20/2011)
What I actually plan to do on a weekly basis is to do 1 full backup on the Sunday's. And then, on twice a day, do a transaction backup.
Twice...
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
November 20, 2011 at 3:38 am
spaceinvaders (11/20/2011)
I need to release free space to the OS or free up space in simple terms because I am loosing disk space.
That's pretty normal, databases do grow.
This server...
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
November 20, 2011 at 3:36 am
First question - why do you want to release space to the OS? Free space in a database file is not a problem, in fact, SQL needs some free space...
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
November 20, 2011 at 2:22 am
Viewing 15 posts - 22,081 through 22,095 (of 49,552 total)