Viewing 15 posts - 7,681 through 7,695 (of 49,552 total)
Loads, no.
VLFs affect things which read the log. Restores, database recovery, that kind of thing.
The 10% growth is the problem here. You should have fixed intervals for growth, 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
September 26, 2014 at 3:12 am
There's a reason Grant and I both recommend using traces or extended events....
The query which you decided to use instead only shows currently executing queries, which is near useless if...
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 26, 2014 at 2:47 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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 26, 2014 at 2:43 am
All tables, almost without exception, should have a well-chosen clustered index.
http://www.sqlservercentral.com/articles/Indexing/68563/
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 26, 2014 at 2:40 am
Fair collection of questions. So what were your answers to them?
When you researched them after the interview, did you come up with anything that you're not sure you understand...
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 25, 2014 at 11:57 am
Vimal Lohani (9/25/2014)
Can't we get that from logs.
No.
Is there any query??
No.
If it's not in the default trace, you haven't set up auditing and you aren't using source control, you cannot...
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 25, 2014 at 8:09 am
You can look in the default trace, but it only keeps a short amount of history, 5 files of 20MB. Other than that, unless you have some DDL auditing, no.
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 25, 2014 at 7:07 am
waeva (9/25/2014)
Andrew - It is a different server however - backup taken on PRODUCTION, while restore done on TESTbut the logical & physical & database names are exactly same.
It's 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
September 25, 2014 at 6:29 am
HanShi (9/25/2014)
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 25, 2014 at 3:50 am
amns (9/25/2014)
declare @int int = 123;
select column1,column2 from table where colInt = @int
(1 row(s) affected)
logical reads 7
SQL Server Execution Times:
CPU time =...
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 25, 2014 at 3:14 am
ying.wang (9/24/2014)
I have realized that when I do full backup, only inactive logical log file are cleared and active logical log file is still intact
No!
Full backup does not clear...
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 25, 2014 at 2:38 am
SQLRNNR (9/24/2014)
declare @string varchar(50) = 123;
select column1,column2 from table where colString = @string
This should cause an implicit conversion and wouldn't be far fetched when somebody...
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 25, 2014 at 2:37 am
If you're going to look at waits, you have to filter out the benign waits. All but one of the ones you've mentioned should be ignored. See Jonathan Keyhaius's blog...
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 25, 2014 at 2:35 am
patelchandresh330 80387 (9/25/2014)
huge amount of data page scanning and logical reads happen by this procedure..
Then you probably want to focus on tuning the procedure so that it doesn't need to...
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 25, 2014 at 2:32 am
This is a Microsoft SQL Server forum, we're not in general MySQL people here. Maybe try asking this over at http://forums.mysql.com/?
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 25, 2014 at 2:31 am
Viewing 15 posts - 7,681 through 7,695 (of 49,552 total)