Viewing 15 posts - 12,841 through 12,855 (of 49,552 total)
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
June 10, 2013 at 3:31 am
DBA_007 (6/10/2013)
since sqlserver is the only one running in the machine why do we need to set Max memory setting
You don't absolutely have to set it, but if you don't,...
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
June 10, 2013 at 3:14 am
Perfectly normal. Unless you set max server memory otherwise, SQL can and will use as much memory as is available on the 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
June 10, 2013 at 3:11 am
Sai Viswanath (6/10/2013)
So, what do now?
Tune the queries, tune the indexes. If they won't allow that then they must accept that performance will remain poor.
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
June 10, 2013 at 3:07 am
Normal, expected, documented behaviour. Nothing wrong at all.
If you want SQL to use less memory, set max server memory so that it knows that it's not allowed to use 100%...
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
June 10, 2013 at 3:05 am
Bhaskar.Shetty (6/10/2013)
Dont think changing datatype will have any significant performance change, unless these columns are used in where clause or filteration purpose.
Unlikely to have an measurable effect even if 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
June 10, 2013 at 2:35 am
UncleBoris (6/10/2013)
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
June 10, 2013 at 2:34 am
Sai Viswanath (6/10/2013)
yes the guys who have designed the db have created indexes on almost all the columns present in the table.
Well that's a problem right there. Single column nonclustered...
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
June 10, 2013 at 2:31 am
Tune the queries, tune the indexes.
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
June 10, 2013 at 12:42 am
Unlikely to have a noticeable effect on performance
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
June 10, 2013 at 12:00 am
Bad parameter sniffing.
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
https://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/
Or maybe stale stats.
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
June 9, 2013 at 11:50 pm
Rename the file on disk to me model.ldf. Fastest fix.
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
June 9, 2013 at 11:45 pm
In that case, -f is documented at http://msdn.microsoft.com/en-us/library/ms190737.aspx
Starts an instance of SQL Server with minimal configuration. This is useful if the setting of a configuration value (for example, over-committing memory)...
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
June 9, 2013 at 1:48 pm
-f on the SQL Server executable is not a format file setting. It's minimal configuration startup option.
The -f parameter on BCP.exe specified a format file, and on BCP.exe -F specifies...
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
June 9, 2013 at 1:11 pm
You need free space equal to the size of all the files of the source database, not the size of the backup file.
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
June 9, 2013 at 12:48 pm
Viewing 15 posts - 12,841 through 12,855 (of 49,552 total)