Viewing 15 posts - 13,726 through 13,740 (of 49,552 total)
New persopn (3/26/2013)
if yes is there any impact on server
Impact, you kill all user connections (by restarting the service) then single user mode allows only a single user to connect.
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
March 26, 2013 at 4:40 am
Small tables would take slightly more space, looking for disadvantages and any effective gains is why you test before enabling in production.
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
March 26, 2013 at 4:36 am
Please read through 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
March 26, 2013 at 2:13 am
Have you tested and seen that the traceflag benefits you and your workload?
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
March 26, 2013 at 2:12 am
You'll need to schedule log backups. Frequency should be based on the RPO of the database mostly and on the volume of log records second.
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
March 26, 2013 at 2:11 am
muthyala_51 (3/25/2013)
how can i find particular spid in sql server which is consuming more cpu?
Please read the book chapter I linked, it explains that and more.
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
March 26, 2013 at 2:05 am
Depends how many tables you have to go through to get that column to filter on.
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
March 25, 2013 at 3:51 pm
SQL_Surfer (3/25/2013)
Ah...I thought it truncates the log as well.
Yup, that's exactly what it does, truncating the log is the process of marking 0 or more virtual log files 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
March 25, 2013 at 3:47 pm
Row level security is a nightmare on a well-designed database. Worked on a system once that used it, so much hassle, so much work required.
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
March 25, 2013 at 3:38 pm
SQL_Surfer (3/25/2013)
After I take the log backup, shouldn't I see the decrease in size of my transaction log file?
No. Log backups just mark space in the file as reusable.
Do I...
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
March 25, 2013 at 3:36 pm
First thing, set max degree of parallelism back to default or to the number of cores per NUMA node. Parallelism is a good thing. If queries are paralleling inappropriately, 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
March 25, 2013 at 3:26 pm
abitguru (3/25/2013)
I make an index to the field I use in where clause. If I understand I make this and have same results, I will try other hints.
As I said,...
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
March 25, 2013 at 3:17 pm
abitguru (3/25/2013)
3...
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
March 25, 2013 at 3:15 pm
abitguru (3/25/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
March 25, 2013 at 3:01 pm
Please note: 5 year old thread.
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
March 25, 2013 at 10:45 am
Viewing 15 posts - 13,726 through 13,740 (of 49,552 total)