Viewing 15 posts - 17,731 through 17,745 (of 49,552 total)
opc.three (7/9/2012)
GilaMonster (7/9/2012)
Double the files. You want to have them in proportion to the CPUs.
This is the first time I have heard this. Do you have a reference by chance...
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 9, 2012 at 2:20 pm
Nasty.
Try going to 16 files, might help a bit. You can always remove the extras if they don't help.
I might also suggest more memory for the server. Again, might 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
July 9, 2012 at 1:54 pm
You cannot create one index to combine all 4, the key columns are different.
Given those indexes, and assuming that all are actually necessary to improve the query's performance to acceptable...
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 9, 2012 at 12:47 pm
That's the output from1204, which is very limited and very hard to interpret. 1204 should only be used on SQL 2000 where it's the only option. 1222 produces much better...
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 9, 2012 at 12:41 pm
Many possible things.
Restart SQL (though if TempDB is sized correctly for its usage that shouldn't reduce it much)
Move files to other drives (TempDB should be separated from user DBs 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
July 9, 2012 at 12:39 pm
Double the files. You want to have them in proportion to the CPUs.
That said, it's rare for files > CPUs to help much. There are cases where it does,...
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 9, 2012 at 12:24 pm
Locks or latches?
Is there any chance of tuning the web app to not use TempDB so heavily?
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 9, 2012 at 11:39 am
SSRS and reports that the execs can run that show them history from the custom history tables?
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 9, 2012 at 11:37 am
n.heyen (7/9/2012)
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 9, 2012 at 9:43 am
Don't shrink TempDB. Leave it be and work out what is requiring so much space, then see if you can fix it.
As for log growth. 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
July 9, 2012 at 9:40 am
Why are you using @@Error and Goto and not a try catch block?
Also, if the completed is No by default, why the update to set it to no first? Why...
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 9, 2012 at 9:23 am
Sim-473257 (7/9/2012)
So, am I right in thinking that the GETDATE() value in...
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 9, 2012 at 8:03 am
Define 'doesn't work'?
Dynamic SQL is about the only way you're going to do this without writing hundreds of SQL statements.
Curious, why information schema and not the catalog views (sys.tables, sys.columns,...
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 9, 2012 at 6:52 am
Well, personally I would assume that if someone states that there is a problem with log backups failing now, they worked at some point, it would be really weird 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
July 9, 2012 at 6:03 am
There is no way to answer that without sitting down at your server and investigating.
With 24GB of memory, 4GB should be left for the OS, so SQL server and SSIS...
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 9, 2012 at 5:55 am
Viewing 15 posts - 17,731 through 17,745 (of 49,552 total)