Viewing 15 posts - 7,051 through 7,065 (of 49,571 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.
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...
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...
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?
December 10, 2014 at 1:48 am
I suggest you consult a dBase manual, or ask the person who gave you the file.
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.
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 =...
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.
December 9, 2014 at 2:20 am
Ian_McCann (12/9/2014)
But there is no change...
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.
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,...
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...
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...
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...
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...
December 9, 2014 at 1:16 am
Viewing 15 posts - 7,051 through 7,065 (of 49,571 total)