Viewing 15 posts - 6,106 through 6,120 (of 49,552 total)
N.D (4/22/2015)
I may have misheard, I know that it's using tempdb to help with contention and I always get them muddled up
Both Snapshot and Read Committed Snapshot do that, it's...
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
April 22, 2015 at 3:14 am
Now that's really weird. A select shouldn't need to be allocating pages and hence should not have to take UP latches on allocation pages.
Why do you have both snapshot and...
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
April 22, 2015 at 3:06 am
There are many, many, many articles, videos, probably even books on SQL Injection. Please spend some time with google (and with your senior developers) and read up on it. It's...
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
April 22, 2015 at 3:04 am
Two things.
First, and most important, your procedure is vulnerable to SQL Injection. Please do some reading up on SQL Injection and fix the vulnerability. This should be your top priority...
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
April 22, 2015 at 2:52 am
Rob Reid-246754 (4/21/2015)
e.g likeUPDATE STATISTICS [dbo].[tbl_TRAFFIC_VISITORS] _WA_Sys_0000000C_1DE57479 WITH FULLSCAN
Yup, exactly like that, although you don't need to specify the stats name, specify the table name and all stats 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
April 21, 2015 at 8:07 am
A product (software product) named "Backup Exec". It's a backup tool used to back up files and machines.
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
April 21, 2015 at 6:59 am
Use update statistics with the FULLSCAN option.
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
April 21, 2015 at 6:23 am
domingo.sqlservercentral (4/21/2015)
UPDATE Persons
SET P_Id=0,...
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
April 21, 2015 at 5:20 am
MotivateMan1394 (4/21/2015)
yesssssssIndex on shceme . (Not on table)
No! Table on partition scheme.
If you want to partition the table, you need to partition the actual table, not one index 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
April 21, 2015 at 5:14 am
domingo.sqlservercentral (4/20/2015)
CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')but... it works independly for these columns, as two simple check constraints.
That's one check constraint that checks both columns, it's not two independent...
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
April 21, 2015 at 5:11 am
N.D (4/21/2015)
The CPU was being hammered at the time, is it possible that this could have contributed to thie contention?
No. GAM pages are only updated (the pagelatch_up) when an...
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
April 21, 2015 at 4:10 am
MotivateMan1394 (4/21/2015)
But steal the size of my new mdf files are the default size and all data are in old mdf files.
Yes, because you haven't partitioned any of your 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
April 21, 2015 at 4:08 am
It's the application Backup Exec. The sysadmin probably has it configured to back SQL Server up as well as the machine. Have a chat with him and make sure you...
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
April 21, 2015 at 3:56 am
N.D (4/21/2015)
This database doesn't have any create / drop table
Weird. You shouldn't be seeing severe GAM contention in a user DB... If it happens again, can you capture the queries...
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
April 21, 2015 at 3:43 am
An index on a view is only fired if a change is made to the view. It won't fire if you insert/update the tables. Put triggers on the tables for...
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
April 21, 2015 at 3:26 am
Viewing 15 posts - 6,106 through 6,120 (of 49,552 total)