Viewing 15 posts - 4,006 through 4,020 (of 49,552 total)
To follow up on Grant and Eric's comments.
Splitting to spread out IO load and splitting to allow partial database restores require completely different decisions about what tables/indexes go onto different...
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
December 15, 2015 at 2:08 am
Nested loop joins may fetch the same row many times from the outer table, and if there are functions there they might get evaluated before the join. Also you may...
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
December 14, 2015 at 8:54 am
Are you planning to put all the files on the same set of drives?
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
December 14, 2015 at 8:47 am
Ed Wagner (12/14/2015)
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
December 14, 2015 at 5:20 am
anthony.green (12/14/2015)
What I've used in the pastIdera, Spotlight, SQL Sentry, all are good, all did what we needed in their own way.
and I've used
SQL Monitor, Foglight and Spotlight. All good,...
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
December 14, 2015 at 4:55 am
As Anthony said
Its then up to you to choose which one fits the needs of your business and your requirements.
What's best for my requirements may not be best for yours,...
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
December 14, 2015 at 4:09 am
This is a Microsoft SQL Server forum, not MySQL. You'll probably get better MySQL help 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
December 14, 2015 at 3:36 am
Ok, the log reader is failing. Why? What steps have you taken to debug the log reader?
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
December 14, 2015 at 3:36 am
Never heard of conditional. The states that a process may be in are running, runnable, suspended, background (for system processes) and sleeping.
https://msdn.microsoft.com/en-us/library/ms177648.aspx
Running means just that, the process is on 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
December 14, 2015 at 3:34 am
Custom ETL won't satisfy any of those requirements (except maybe 4). To even start, you'd probably need to write IO filter drivers, or maybe a transaction log reader, implement 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
December 13, 2015 at 2:20 pm
https://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx
http://dba.stackexchange.com/questions/28801/sql-server-ntfs-allocation-unit-size
Bear in mind that changing the size means repartitioning the drives, so that's a re-partition, re-format and reinstall. Downtime could be nasty.
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
December 13, 2015 at 6:24 am
Welsh Corgi (12/13/2015)
When I start the Log Reader Agent it fails.
And you've, of course, looked at the errors it logs, googled them if you don't understand immediately and hence know...
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
December 13, 2015 at 6:19 am
I just told you! And the error message that you posted told you as well!
You've either got transactional replication with a log reader job that's not running or change data...
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
December 13, 2015 at 3:01 am
Continues here: http://www.sqlservercentral.com/Forums/Topic1744862-2799-1.aspx
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
December 13, 2015 at 2:57 am
Yes. Remove the UDFs. They're a notorious performance problem, especially when they're data-accessing UDFs that run in a clause of a query, because they will run multiple times and, as...
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
December 13, 2015 at 2:51 am
Viewing 15 posts - 4,006 through 4,020 (of 49,552 total)