Viewing 15 posts - 4,186 through 4,200 (of 49,552 total)
You cannot log ship down-version. A SQL 2012 database cannot be restored to a sQL 2008 R2 server, neither can log backups, so that's not going to happen.
Log shipping up-version...
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
November 25, 2015 at 5:09 am
yakko_Warner (11/24/2015)
So, the long and short of it is that TDE did indeed cause increased overhead and the server was not sized correctly to handle the I/O load.
TDE won't increase...
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
November 25, 2015 at 1:52 am
g.britton (11/24/2015)
I'm thinking something else is going on, or something is not documented. deferred resolution is documented within the context of creating a stored procedure, which I get.
I'm pretty...
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
November 24, 2015 at 2:41 pm
Nothing to do with transactions. That's a parse-time error (well, binding phase, not the parser itself). The algebriser sees that the object is being created twice as it binds 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
November 24, 2015 at 1:32 pm
Generally, when partitioning on dates, RANGE RIGHT is easier to work with.
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
November 24, 2015 at 12:22 pm
yakko_Warner (11/24/2015)
it's not i think the TDE caused table/index fragmentation.
TDE won't cause index fragmentation. It's applied as the pages are written to disk, doesn't change where the pages are...
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
November 24, 2015 at 11:10 am
You run the ALTER and you wait until the background thread finishes, and that should be it.
Why is a CPU usage of 20% a concern?
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
November 24, 2015 at 9:23 am
One of the execution-related DMVs, either ...exec_sessions or ...exec_connections, depending what you're trying to do.
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
November 24, 2015 at 8:43 am
Odd... Maybe a side effect of it being a deprecated view.
Why are you using sysprocesses anyway? It's included only for backward compatibility with SQL 2000.
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
November 24, 2015 at 8:24 am
Can you show some examples? Attach a screenshot?
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
November 24, 2015 at 8:03 am
Yes, because
GilaMonster (11/24/2015)
Create Partition Scheme Yearly_Date_Range_ps
As PartitionYearly_Date_Range_pf
All To ([Primary]);
Go
You're missing a space. The partition function is named Yearly_Date_Range_pf, and you left out the space between the PARTITION keyword and 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
November 24, 2015 at 7:55 am
Create Partition Scheme Yearly_Date_Range_ps
As PartitionYearly_Date_Range_pf
All To ([Primary]);
Go
You're missing a space. The partition function is named Yearly_Date_Range_pf, and you left out 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
November 24, 2015 at 7:22 am
jasona.work (11/24/2015)
ThomasRushton (11/24/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
November 24, 2015 at 6:19 am
If Windows pages SQL's memory out to the page file, there will be a message in the error log. SQL doesn't use the page file itself.
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
November 24, 2015 at 3:47 am
Btw, Khalid, you have a SQL Injection vulnerability in your code, potentially allowing any random user to steal your database, change data, or drop the entire database. For the sake...
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
November 24, 2015 at 1:51 am
Viewing 15 posts - 4,186 through 4,200 (of 49,552 total)