Viewing 15 posts - 7,051 through 7,065 (of 49,552 total)
Probably the limit of the number of objects in a database. That's 2.3 billion, give or take.
Memory is NOT the limit as temp tables are not memory-only.
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 10, 2014 at 2:24 am
Tac11 (12/9/2014)
Should I put Snapshot database's Data and Log files point (put it) to another server? Is it possible?
No.
I just don't want to give the Prod server extra load.
Then...
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 10, 2014 at 2:16 am
Neither of those values have anything to do with the query. The majority of that will be the SQL buffer pool, the plan cache and various other caches. They're not...
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 10, 2014 at 1:50 am
Why does the application user need information on deadlocks? What is an end user going to do with it?
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 10, 2014 at 1:48 am
I suggest you consult a dBase manual, or ask the person who gave you the 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
December 9, 2014 at 3:21 am
Str file as in the schema definition for a dBASE database? If so, you'll probably need a dBASE database to interpret it.
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 9, 2014 at 2:33 am
btw, you say there's no change in performance in your tests, but there is.
Ian_McCann (12/9/2014)
SQL Server Execution Times:
CPU time = 0 ms, elapsed time =...
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 9, 2014 at 2:30 am
Except if you look at the execution plan, there's no 'recursion' anywhere and correlated subqueries are not automatically horrible things.
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 9, 2014 at 2:20 am
Ian_McCann (12/9/2014)
But there is no change...
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 9, 2014 at 2:18 am
Is google down?
I don't have a saved query handy, so either you search for it, or I have to search for it and post.
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 9, 2014 at 1:55 am
I think you're missing the point of a replay. A replay replays the workload against the target server. The entire workload. If that workload that you're replaying does data modifications,...
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 9, 2014 at 1:32 am
DSNOSPAM (12/8/2014)
I could have table results with hundreds of thousands of records. I THINK I read that that is not a good use for table variables.
Correct
If I use just...
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 9, 2014 at 1:30 am
Jack Corbett (12/5/2014)
GilaMonster (12/5/2014)
And crisis, panic, run around screaming, the EF-based app is slow.600MB database, generating 5GB of trace data in 1 hour....
Ouch, I don't even think...
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 9, 2014 at 1:22 am
Tac11 (12/8/2014)
My question is can I created a snapshot of the prod database on the same server and run DBCC CHECKDB on the Snapshot DB?
You can, but there's little...
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 9, 2014 at 1:18 am
Unless you had something running when the deadlock occured (traceflags, extended events), no. There's a slim chance that it'll still be in the system health extended events session, but...
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 9, 2014 at 1:16 am
Viewing 15 posts - 7,051 through 7,065 (of 49,552 total)